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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
jdellamag
Regular Visitor

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

@jdellamag , 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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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