Forum Discussion
Dynamic total/subtotal in a matrix
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 measur...
Hi Anonymous
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.
V-yubandi-msft
Community Support
Community SupportHi Anonymous ,
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.