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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Gems
Advocate I
Advocate I

Show a message when there's no data

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'. 

Gems_0-1671133948173.png

 

1 ACCEPTED 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","")

 

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

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","")

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors