Forum Discussion
Table - space between specific rows
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.
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.