Please note javascript is required for full website functionality.
MVP

Blog

Power BI Blog: Leave a Line

22 July 2021

Welcome back to this week’s edition of the Power BI blog series.  This week, we will look at how to leave a blank line in a Matrix visualisation.

 

Last week, I had a simple table of accounting data, which I created a Matrix for:

I used a measure which I called asterisk

*  = “ “

to create a line in my Matrix.

Today, I have imported rental data into a new table called Rent:

I want to include a calculation based upon this data in the same Matrix I created last week.  I have created a relationship between the Rent and Accounts tables:

In this very simple example, I can use a 1 to 1 relationship using the Month field.

I can create a new measure to work out the Net Rental Income:

Net Rental Income = CALCULATE(SUM(Rent[Rental Income]) – SUM(Rent[Overheads]))

This is very similar to the Profit measure I created last week.  Now I can add Rental Income, Overheads and Net Rental Income to my Matrix.  I include the asterisk measure before Net Rental Income to insert a line.

There are a couple of changes I want to make to the formatting.  Now I have more lines, I would prefer to see the line all the way across to the row names.  I can do this in the Formatting pane in the ‘Field formatting’ section for the asterisk measure.

If I toggle ‘Apply to header’ to On, then the line is extended for both occurrences of my asterisk measure:

This is looking better, but I’d like to leave a gap between Profit and Rental Income.  I can do this by creating another measure:

“” = “ “

I will refer to this as the blank measure.  I add the blank measure to my Matrix.

I have a space, but it’s a bit thin.  I can just add more blank measures until I am happy with the gap.

This gives me a gap I am happy with.  For this Matrix, I want the font and background colour of the blank measure to be white, but this will depend upon the formatting chosen for each Matrix.

I can now add a Total Net Income measure.

Total Net Income = [Profit] + [Net Rental Income]

I add this to my Matrix and format it with more asterisk and blank measures.  I also alter the background in the ‘Field formatting’ section of the Formatting tab for each field to give my Matrix a more balanced appearance.

Check back next week for more Power BI tips and tricks!

Newsletter