Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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","")