Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I am trying hide header part of Matrix table (PowerBI) Please see screen shot below to see what i am looking for
The expected format is below;
As you can see i would like to make header name like (A,B,C,D) is invisible. Currently im using a retangle to hide is, but is still can see if im resize or click in visual, Is there any other way than covering it with pictures?
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
Solved! Go to Solution.
Hi @Em3dream123
There isn't a formal way to achieve this, but it is possible to get something simlar with a workaround.
What you can do, is replace the values you wish with blank spaces, of course this is dependent on how much data you have.
To achieve this, I added a rank to my hierarchy to get a separate (low) rank number. I then used this number to create a column coprusing n blank spaces depending on the rank, if it was marked as invisible, or the level itself:
Lvl1 Rank = rankx(all(Sheet1[Lvl1]),
CALCULATE(sum([Value]),ALLEXCEPT(Sheet1,Sheet1[Lvl1]))
,
,DESC
,Dense)
Lvl1 fmt = if(Sheet1[Invisible],REPT(" ",Sheet1[Lvl1 Rank]),Sheet1[Lvl1])
In Lvl1 fmt, the value is 6 spaces " " for Lv1 = a
and 4 spaces " " for Lvl1 = b
Applying this to the matrix makes the values appear "invisible" (but they are really just blank spaces)
HTH
Pi
@Em3dream123 that's great to hear! If so, can you mark my answer as correct please?
Hi @Em3dream123
There isn't a formal way to achieve this, but it is possible to get something simlar with a workaround.
What you can do, is replace the values you wish with blank spaces, of course this is dependent on how much data you have.
To achieve this, I added a rank to my hierarchy to get a separate (low) rank number. I then used this number to create a column coprusing n blank spaces depending on the rank, if it was marked as invisible, or the level itself:
Lvl1 Rank = rankx(all(Sheet1[Lvl1]),
CALCULATE(sum([Value]),ALLEXCEPT(Sheet1,Sheet1[Lvl1]))
,
,DESC
,Dense)
Lvl1 fmt = if(Sheet1[Invisible],REPT(" ",Sheet1[Lvl1 Rank]),Sheet1[Lvl1])
In Lvl1 fmt, the value is 6 spaces " " for Lv1 = a
and 4 spaces " " for Lvl1 = b
Applying this to the matrix makes the values appear "invisible" (but they are really just blank spaces)
HTH
Pi
im try your way , its quite good for me now, tks
Hi @Em3dream123
Unfortunately, we don't have the functionality to format separate column heathers by hierarchy level.
There is an idea that includes this issue please vote for it ( i voted) 🙂
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=370a6312-dd80-eb11-8ced-501ac5245bf1
If the matrix is without side-scrolling you can hide it with small white shapes.
OR
Create a report with report builder.
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |