Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
My organization will be releasing grant competition results and I have been tasked with creating an interactive dashboard. Users will be able to filter competition results by many factors (gender, career stage, institution, etc...) to compare success rates among various groups. Our policy is to not publish any statistics based on n<5 because of their lack of significance, and the potential for individuals to be identified through reductive filtering. Is there a way to limit data display by n value?
IF the n<5 relates to a column, you could simply filter it out within the Transform Data Section (M Code). If you need the aggregate data for measures, but you simply do not want to drill into the details, an option would be Duplicate the data within M Code and then filter this copied table. Then you create measures on your original table, and then drill into the duplicate table that is filtered in the background.