Forum Discussion

jbittinger's avatar
jbittinger
Regular Visitor
9 years ago
Solved

Exclude cells with small sample sizes

New to Power BI and trying to get my bearings. I'm working with survey (Likert-type) data in a university setting, and as a result, we are concerned about protecting the confidentiality of respondent...
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    jbittinger

     

    Hi, Select the other chart and Go to Edit Interactions (Format Menu) and Select Filter instead of Highlight.

     

    Edit Interactions to Filter

jbittinger's avatar
jbittinger
Regular Visitor
9 years ago

Thanks for the help thus far. When I try this, the problem still exists because it doesn't seem to affect the highlighted numbers (see below). I got to this point by clicking on a bar segment from a belonging graph.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

I don't have any context in relation to this. Is this visualization configured to have a filter of "Count of Diverse" > 5?

  • jbittinger's avatar
    jbittinger
    Regular Visitor
    9 years ago

    Yes, the visual has a Count of Diverse > 5 filter.

    I've pulled a sample from the data and created a sample page. The .pbix file can be accessed here.

     

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      9 years ago

      jbittinger

       

      Hi, Select the other chart and Go to Edit Interactions (Format Menu) and Select Filter instead of Highlight.

       

      Edit Interactions to Filter

      • jbittinger's avatar
        jbittinger
        Regular Visitor
        9 years ago

        Thanks for this solution, I take it there's no way to do this and allow the highlighting option (makes sense, but I was still hopeful).