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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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 Kudoed Authors