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 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
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.
2 Replies
rohit1991Super User
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-msftCommunity Support
Hi 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.