Forum Discussion
Insert Blank lines in Matrix Financial Statement
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 ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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):
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.
Thanks It looks like we cannot insert a completly blank column (not showing the index on screen)
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 ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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 ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.