Forum Discussion

quintoncoish's avatar
quintoncoish
Frequent Visitor
7 years ago
Solved

Is it possible to turn off visualization right-click options

When right-clicking a visualization, i sometimes see the option to:

  • See Records
    • update: you can sort of turn "see records" off by
      1. going to data view
      2. right clicking each table and selecting "hide in report view"
      3. unfortunately, you still see "See Records", which just becomes similar to "See Data" but exposes any field you use for an aggregation (kinda scary)
  • Include
  • Exclude

 

I'd love to turn those 3 options off.  Is there a way? 

 

Thanks,

Quinton

Need Help
  • quintoncoish's avatar
    quintoncoish
    7 years ago

    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.

     

     

4 Replies

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi 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.

     

    • quintoncoish's avatar
      quintoncoish
      Frequent Visitor
      7 years ago

      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.