Forum Discussion
Table - space between specific rows
Hello Power BI Community,
I hope everyone is doing well!
I’m currently working on a report with a table visual. I’m looking for an easy and elegant way to create additional space between specific rows (not all the rows across the whole table) without creating a separate table.
Does anyone have suggestions or best practices for achieving this? I would appreciate any tips you can share.
Thank you in advance for your help!
Hi Emma_
In Power BI, a value can’t be assigned to a row that doesn’t exist, even if the intended value is blank. That blank row has to exist first. One way to handle this is to add a dimension table that includes an explicit blank row, like in the example below. The category column also needs a custom sort; otherwise, the blank row will always appear first.
Use this dimension table in the visual and ensure that Show items with no data is enabled
Please see the attached pbix.
2 Replies
Hi Emma_
In Power BI, a value can’t be assigned to a row that doesn’t exist, even if the intended value is blank. That blank row has to exist first. One way to handle this is to add a dimension table that includes an explicit blank row, like in the example below. The category column also needs a custom sort; otherwise, the blank row will always appear first.
Use this dimension table in the visual and ensure that Show items with no data is enabled
Please see the attached pbix.
Perfekt, thank you
