Forum Discussion

maronis's avatar
maronis
Icon for Helper I rankHelper I
8 years ago

Hide data in visualization if too few responses

We have an employee survey and I'm trying to build reports in Power BI. We've promised employees confidentiality so I'd like to suppress data if there are fewer than three respondants.   The output...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

So then we cannot look at absolute numbers at all - your premise of 3 will not be valid in that case.  We must then compute the numbers of respondent/Total population for that group and filter based on that.

maronis's avatar
maronis
Icon for Helper I rankHelper I
8 years ago

Thanks - is there an easy way to do that? I was trying to think of constructing a measure that would count the total number of respondants and filter based on that but I can't for the life of me think of how I'd construct that.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    I need your file for that.  Share the download link.

    • maronis's avatar
      maronis
      Icon for Helper I rankHelper I
      8 years ago

      Thanks for the offer to help! I'm afraid I can't share the actual file but we did manage to find a way to restrict the data regardless. Instead of presenting the histogram view, we're just showing an average of each question ('Strongly disagree' = 1, disagree = 2, etc) and by doing that we can restrict the visualization to only show questions that have at least three responses by using a report-level filter.