Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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-YYYY | sales | Date |
| Q1-2023 | 62 | 12/15/2022 |
| Q2-2023 | 98 | 3/15/2023 |
| Q3-2023 | 55 | 6/15/2023 |
| Q4-2023 | 9/15/2023 | |
| Q1-2024 | 12/15/2023 | |
| Q2-2024 | 65 | 3/15/2024 |
| Q3-2024 | 83 | 6/15/2024 |
| Q4-2024 | 9/15/2024 | |
| Q1-2025 | 12/15/2024 | |
| Q2-2025 | 3/15/2025 | |
| Q3-2025 | 58 | 6/15/2025 |
| Q4-2025 | 75 | 9/15/2025 |
what would be the business value of that text message? Are you afraid that your report users will misinterpret the data?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |