Forum Discussion
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.
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
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
1 Reply
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