Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
@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
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |