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.
Is it possible to show a 'warning message' when there is no data for a variable instead of showing an empty section?
For example, in the bottom there's a big white space. Instead, I need a warning message like: 'For the variable chosen in the slicer, ther's no data'.
Solved! Go to Solution.
Thank you @lbendlin , I've done some research and I find out that crating a Card and adding a measure on it was the easiest solution. Is imporant to adjust the transparency of the card to 100% in order to see the data when there are values to show. If this can help someone, this is the measure I used:
Measure = IF(ISBLANK(SUM('Variable')),"Message you want to display","")
You can use the visual title's fx function, or you can use smart narratives to display the appropriate text.
Thank you @lbendlin , I've done some research and I find out that crating a Card and adding a measure on it was the easiest solution. Is imporant to adjust the transparency of the card to 100% in order to see the data when there are values to show. If this can help someone, this is the measure I used:
Measure = IF(ISBLANK(SUM('Variable')),"Message you want to display","")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.