Forum Discussion
Is it possible to turn off visualization right-click options
The solution from a support ticket with Microsoft
To turn off "see records" don't use aggretations (count, sum, etc) on the value field you're using within the visual. Instead, create a measure for those aggregations and use that in the value field. It's an extra step to use dax to create those measures, which is silly but it'll save you from potentially exposing a full table of data unnecessarily.
Hi Amy (v-xicai) ,
Here's a sample of one on a 100% stacked bar chart
I initially thought I could reduce the amount of data seen in the "see records" by hiding the tables from the report.
However, it seems like it still sneaks some data thought. In this case, since the %'s in the stacked bar chart are based on the unique count of a user's ID, it shows me the user ID in the "See Records" "#of Students" column. I'd like for those ID's to never be seen or be able to be exported.
Amy (v-xicai) Here's a visual on how to replicate this
The solution from a support ticket with Microsoft
To turn off "see records" don't use aggretations (count, sum, etc) on the value field you're using within the visual. Instead, create a measure for those aggregations and use that in the value field. It's an extra step to use dax to create those measures, which is silly but it'll save you from potentially exposing a full table of data unnecessarily.