How can I remove subtotals from multiple dimensions in a Matrix in Power BI

[sandeepkrdas092]

In the matrix below, I want to retain only the green-highlighted totals and remove all the red-highlighted subtotals under Summary. Any suggestions?

[Idrissshatila · Accepted solution]

hello @sandeepkrdas092 ,

so you go to the fornmatting pane for the matrix visual then to the row subtotals, then you click on apply settings to and then you enable the per row level and then you turn it off for the levels you don't want them to show.

[Jonvoge · Accepted solution]

Hi sandeepkrdas092

Does it help to toggle "per row level" in your Row Subtotals formatting, and disabling individually for the levels you wish to hide?

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[Jonvoge · Accepted solution]

Hi sandeepkrdas092

Does it help to toggle "per row level" in your Row Subtotals formatting, and disabling individually for the levels you wish to hide?

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[sandeepkrdas092]

Thank you so much Jonvoge, I got the solution.

[sandeepkrdas092 · Accepted solution]

Hi Jonvoge,

Thanks for the response. I followed the same steps, but it's not working for me. Please refer to the screenshot.

[Idrissshatila · Accepted solution]

hello @sandeepkrdas092 ,

so you go to the fornmatting pane for the matrix visual then to the row subtotals, then you click on apply settings to and then you enable the per row level and then you turn it off for the levels you don't want them to show.

[sandeepkrdas092]

Hi idrissshatila,

Thanks for the response. I followed the same steps, but it's not working for me. Please refer to the screenshot

[Idrissshatila]

@sandeepkrdas092 ,

you need to remove for column 3 and column 4.

[sandeepkrdas092]

Thank you so much, I got the solution.