Forum Discussion
Hiding Matrix row headers
- Anonymous4 years ago
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:
Thanks for all the suggestions. I tried to leave the measure name blank or add a space for the name but I get the message "model object names must be non-empty". I tried to hide the row header with a text box but the text box renders in different locations on the page depending on whether the user is viewing the report from a desktop, laptop, or ipad due to different screen sizes. In other words, the text box may hide a valid row header.
It can be maddening to do something in Excel so easily, like hiding or removing a row header, and so difficult or impossible in Power BI. If anybody has a eureka moment, please share :)
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.
- Anonymous6 years agoNot applicable
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.
- Anonymous7 years agoNot applicable
Thanks for the suggestion.