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