Insert Blank lines in Matrix Financial Statement

[samantha75]

Hi Everyone

Thanks for helping me out with the fin rpeort and I'm very close to the final version. One question I  have is inserting blank lines to separate row sections for example insert a line below:

the statement above is driven by an excel template. The problem is if I show lines without figures all other unwated lines are displayed so some sort of conditioal display is required

[samantha75]

I think my requirement is not clear. How do you add a blank row in matrix report? for example see below example for the format required after adding the blank rows (in Yellow):

[v-xingshen-msft · Accepted solution]

Hi @samantha75 ，

If you want to add blank columns to Reporting Heading, you can manually add blank rows to Reporting Heading in the dataset.

And then add an index column, sort it, and return to desktop to generate blank rows.

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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

[samantha75]

Thanks It looks like we cannot insert a completly blank column (not showing the index on screen)

[v-xingshen-msft]

Hi @samantha75 ,

Regarding our discussion, I wonder if this issue has been resolved by now? It's been a long time since I've heard back from you and I'm not sure if all is well. Please feel free to let me know if there is anything else I can do to help.

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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

[v-xingshen-msft]

Hi @samantha75 ,

I think your understanding is correct, as I am doing now, I am adding a lot of blank rows to the data, but in power bi these blank rows are automatically aggregated, so referencing the index column is necessary.

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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

[v-xingshen-msft]

Hi @samantha75 ,

You can see that you have correctly added blank rows to your matrix, but you want to hide extraneous columns and don't want the extra blank columns to appear.

You can create a new table to hide other columns from you.

Table2= SELECTCOLUMNS('Table',"ReportHeading",[ReportHeading],"Operator",[Operator])

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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