The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.