Sometimes show, sometimes hide matrix row subtotals depending on category

[ErikBi2]

Hey!

I have a visual where, depending on the category it does or does not make sense to show the sum of row subtotals.

Is there a way to choose when to hide/show these within the same visual? I was thinking of conditional formatting and making the ones i don't want to show white, but there is no fx button for value colours. Does anyone have a different idea?

Example below: Show row subtotals for only category 1 and 3. Do not show for category 2.

Settings of matrix visual does not seem to allow such thing.

 

[ErikBi2 · Accepted solution]

Ive found the solution. I needed to look at Cell elements. There I could specify the conditional formatting of the values specified by my measure.