Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Blur or block out chart based on a single distinct count

Hi there,

 

My scenario is this: I have a PowerBI dashboard that consists of 5 charts, each correlating to a different category that is on a client survey we distribute. Clients have the choice to not fill out the survey, so some months we get very few completed surveys. Would there be a way in PowerBI to blur all of the charts or the entire page if there were to be too few surveys completed in a month? So let's say the distinct count of survey IDs is less than 10, could I blur all of the charts on the dashboard, but if over 10 completed make them all visibile?

 

Thank you in advance!

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , You can create a measure

 

m1= countrows(allselected(Table))

 

You can now use this in visual level filter of all visual and use m1 >5,means all visual not show unless count > 5

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.