Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 my Matrix visual to make the income statement more readable. However, I cannot hide the row headers so that the user cannot see them. Any ideas? Thank you.
Solved! Go to Solution.
Try this:
1. Create measues:
It should look like this:
@appsac in field formatting you can change the foreground and background color the same to hide the header.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thanks for the feedback parry2k. I assume when you say foreground color you are referring to font color. Under field formatting, I have the font color and the background color both set to white. This hides the values but not the row header. I need to hide both. Here is screen shot of what matrix row headers look like today:
There is an option below the Field Formatting where you can choose whereyou want to apply the Format you made.
I have "Apply to header" turned on, but it does not affect the header at all.
You will be able to hide the font in the Row Headers if you change the font color and background color to white.
https://community.powerbi.com/t5/Desktop/hide-matrix-headers/m-p/498078#M232309
Currently it doesn't seem that it is an option to change just one or a few Column Headers though, although there are a few workarounds.
Hi, In my case, "" or blank is not letting me hide the field name. Any other suggestions?
Try this:
1. Create measues:
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |