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.
Community SupportHi quintoncoish ,
In Power BI Desktop, when you right-click on a visual, just showing the options below, no See Records, Exclude and Include options as you said, could you please show your issue page in screenshot?
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.