Forum Discussion
Hiding Matrix row headers
I have created an income statement using a Matrix visual. I have created 5 measures named 1-5. Each measure uses the blank() function. Example: 1=blank(). This allows me to insert blank rows in ...
Try this:
1. Create measues:
1 = blank()2 = blank()etc.2. Add measures to your matrix where you want a blank line:3. Use field formatting to make foreground and background white for your new measures;It should look like this:
The best solution i have came to was using the "shapes" figures, selecting a rectangle and applying the white color to both line and fill.
It seens to work like i wanted to, do you know if this is in anyway different to text box and background color? Can't test right now to different screen sizes i guess.
Thanks for the suggestion.
This is indeed a shame. The thing is if you turn off "Show on rows", then formatting the field will actually work as expected by aligning the font color to the background. But if you turn this on, then it will not work at all. Power BI still needs to make small things work as intended while adding new and cool stuff.