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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Ansu8371
Frequent Visitor

how to display text message if we have no data for certain quarters

Is there a way to display text message if we have blank data for certain quarters like "There is no data available for the range selected" or "There is partial data available for the range selected" for certain quarters when we are comparing sales of two years with same quarter like Q1-2024 to Q1-2023 in bar chart?

 

QQ-YYYYsalesDate
Q1-20236212/15/2022
Q2-2023983/15/2023
Q3-2023556/15/2023
Q4-2023 9/15/2023
Q1-2024 12/15/2023
Q2-2024653/15/2024
Q3-2024836/15/2024
Q4-2024 9/15/2024
Q1-2025 12/15/2024
Q2-2025 3/15/2025
Q3-2025586/15/2025
Q4-2025759/15/2025
1 REPLY 1
lbendlin
Super User
Super User

what would be the business value of that text message? Are you afraid that your report users will misinterpret the data?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors