Dynamic total/subtotal in a matrix

[Elieekh17]

hello Community,

I have a matrix table , I need to allow users to show / hide rows subtotals however I am using a personlized visual option so users can add rows/ columns to the matrix and measures.

How to allow them display or not the rows subtotals. I tested the bookmarks but it seems this is a limitation since personalized visuals do not support this. any ideas ?

Thank you

[V-yubandi-msft]

Hi @Elieekh17 ,

@rohit1991 , correctly pointed out that when using Personalize Visuals, end users currently do not have control over matrix subtotal settings, and bookmarks may not function as expected.

Regards,
Community Support team.

[rohit1991 · Accepted solution]

Hi @Elieekh17 

When using Personalize Visuals in Power BI, there isn’t currently a way for end users to toggle matrix subtotals on/off themselves, and bookmarks don’t work because the visual can be changed by users.

Right now, subtotal visibility in a matrix can only be controlled in the visual’s Format pane by the report designer, not dynamically by users in the Service with personalization enabled.