Hide Column Subtotal for Specific Values in Matrix Visualization

[PreciousJunk]

Hello,

I have a matrix visualization with 2 rows, 2 columns and 4 values. I would like to hide column subtotal for Value1 and Value4 but it seems there are no straightforward options to do it.

I tried using a measure with HasOneFilter function and tried to remove the subtotal but it doesn't hide the column headers. Is there a way I could acheive it? Thanks

[v-yueyunzh-msft · Accepted solution]

Hi , @PreciousJunk 

According to your description , you wan to hide Column Subtotal for Specific Values in Matrix Visualization.

The current shutdown sub total in the settings cannot be set according to your Value, only according to the Column.
If you want to not show a Total, you can turn off "text wrap":

You can then drag the column with the mouse to hide this SubTotal column that you don't want:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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