Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a dataset with three key columns (country, category, and value). Some countries do not have data in the value column for some categories.
I have certain visuals connected to a country slicer that I would like to display only if there is data, and to have text show up "No data available" when the country selected is empty. Is there a way to do this?
Thanks!
Solved! Go to Solution.
You may add a measure for Card visual.
Measure = IF ( ISFILTERED ( Table1[country] ), SUM ( Table1[value] ), "No data available" )
You may add a measure for Card visual.
Measure = IF ( ISFILTERED ( Table1[country] ), SUM ( Table1[value] ), "No data available" )
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |