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 t...
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])