Forum Discussion

PreciousJunk's avatar
PreciousJunk
Regular Visitor
3 years ago
Solved

Hide Column Subtotal for Specific Values in Matrix Visualization

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.  ...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    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

     

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

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