Hide Matrix Column without value

[Anonymous]

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.

https://imgur.com/a/lsijY4z 

"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,

[Anonymous]

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:

https://imgur.com/a/fs6ibnX 

[v-lionel-msft]

Hi @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 Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

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 columns

[PaulDBrown]

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