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,

 

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.