Forum Discussion
Hide Matrix Column without value
Greetings everyone,
Here's my problem:
I have a matrix where I show the results of indicators in the month (Mês) and YTD (Acumulado).
However, the "P. Final" measure has values only for the YTD.
"P. Final" is basically a CALCULATE(SUM(TAB[Pontuacao]),TAB[Visao] = "Acumulado")
Is there a way to not display this column?
Unfortunately, turning off word wrap in the matrix setting and dragging the field I wanted to hide it's not feasible for me 😞
Any suggestion?
Best regards,
4 Replies
Funnily enough, there was a thread with this same question posted yesterday, so you might want to check it out:
https://community.powerbi.com/t5/Desktop/Hiding-a-column-in-Matrix-but-not-in-total/td-p/1844309
If you want to try hiding the column, turn off the options for "Auto-size column width" and "Word Wrap" under Column headers in the formatting pane:
To avoid getting values for the column, I used this measure for the values of "Previous Year" (which I renamed in the visual):
Hide Previous Year = IF(ISINSCOPE('DIM Product Ref'[Product REF]), BLANK(), [Previous Year])Hi PaulDBrown,
Turning off the options for "Auto-size column width" and "Word Wrap" under Column headers in the formatting pane it's not feasible for me:
You can hack that effect by adding a blank column using a measure = BLANK() and placing it at the bottom of the values bucket (below the measure for [P. Final]). Adjust the width to your liking.
Or, change the order of the last two columnsHi Anonymous ,
There seems to be no good way to hide this column, do you have to hide it? How about setting the null value to 0%?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
