Forum Discussion
How to disable drill down/up in a Matrix Visual
So I am using a matrix visual where i am using a hierarchy--have drilled down for few columns and havn't drill down for other fields depending on the requirments.
Now post publishing the report, I dont wont report users to drill up/down on these visuals, data which is already drill down by me should seem like frozen(Table).
Can you pls help?
You can turn off the '+/- icon' for the stepped layout in Matrix visual,
and Drill up/down for the visual header under Property setting.
3 Replies
- MasonMA
Super User
You can turn off the '+/- icon' for the stepped layout in Matrix visual,
and Drill up/down for the visual header under Property setting.
- Anusha66
Advocate IV
Thank you for the quick reply! The below solution helped me. By doing this, we are not giving user any option to drill down/up.
What is the user of other option that you provided. Tried that, but was still able to drill down/up.
- MasonMA
Super User
It's affecting the visual header options in the Service. After disabling them, even though you can still see the drilling icons on the visual header in Desktop file users won't be able to see them in Service. (To prevent users from expanding your Matrix to next level from visual header, 'Show next level' and 'Expand to next level' can be turned off )