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.
Hi,
I am trying hide header part of Matrix table (PowerBI), however, i would like to keep other part of the Matrix Header (Row and Column Value both). Please see screen shot below to see what i am looking for,
I have this; Red Highlighted part, i would like to remove or hide because currently I have put DOT "." but does not look good.
The expected format is below;
As you can see i would like to keep ROW and COLUMN Headers value but would like to hide Headers name. I can do everything else just not getting how would I hide headers.
Any Suggestion or Advise? Hope this is enough explanation. If you need more please let me know would be more than happy to share with you.
Thanks
There is another way 🙂
In this I have a header over the "green" box, but it is hidden with field formating:
This cannot also be applied to columns where you don't want to show totals for a specific column
Hi @damit23183 ,
For matrix,there's no such functionality that can hide the headers.But i have a workaround for you:
First create a Rectangle,and set the color of "line" and "fill" to white:
Then move the Rectangle to the part where you wanna "hide",press ctrl and right click on the visuals of rectangle and matrix,set "group",as you see below:
Then magic happens:
Hi,
Thanks for your response.
Your idea is good but does not look like it will work because when user move their mouse it will be flip flop show off. This is the reason when user can easily see that hidden part.
Thanks though for nice trick.
Thanks
Hi @damit23183 ,
Pls check whether below links will help:
https://community.powerbi.com/t5/Desktop/hide-matrix-headers/td-p/497460
https://stackoverflow.com/questions/57924019/show-hide-column-in-power-bi-table-matrix-visual
If not,I suggest you propose an idea via below link to make this feature come soon.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
@damit23183 You could create a rectangle shape and overlay that part of the matrix.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |