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

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