Blank row in matrix after each Item

[AnthonyTilley]

Hi All,

Looking for a way to make the matrix in power bi insert a row after each item in a given filed 

this is similar to the insert a balnk row after each item in Excel 

example of how this looks below, there is a blank row after each subtotal that helps to space out the table and make it more readable 

thanks for any help

[Anonymous]

I don't know if this will help many people, because it's only in use cases where you can create a hard-coded table in PowerBI, but if you don't have many categories, this option has worked well for me. I make a table with the headers I want. Where I want blank rows, I put a 0 in my header column. Then I make a calculated column ("Real Header Column") with the formula shown in the screenshot, where it inserts an invisible character as many times as the number of the header row (creating a unique header of blank characters of different lengths for each blank spot). You can connect this outline to your data and use it in matrixes. You may need to write your formula using SWITCH so that when you come to a blank header it inserts the invisible character, to keep your blank rows showing. See a snip of my final P&L below:

I know this wasn't explained real well, but I don't have time to do much better. If you have strong DAX skills, you can probably take some idea from this and make it work for you.

FWIW.

William

[v-lionel-msft]

Hi @AnthonyTilley ,

In Power BI Desktop, although we can show the blank rows, like this:

But, we can’t show blank row after each item. At least, current version of Power BI Desktop can’t realize it (My version is 2.75.5649.761 64-bit (November 2019)).

For your issue, I think you should use power BI’s visualizations feature to create nice, clear tables.

Or you can use custom visuals:

https://powerbi.microsoft.com/en-us/custom-visuals/

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.