Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi All,
How can i show "data not available" or some custom message instead of showing empty chart when there is no data
Thanks & Regards,
Suresh Peddirsi.
Solved! Go to Solution.
Hi @suji,
Currently, power bi visuals not contain this feature, perhaps you can try to use below method which used to check if the table is empty.(IsEmpty function)
Measure:
IsEmpty = IF(ISEMPTY('test color'),"This table is empty","This table contains records")
Result:
In addition, you can also post this requirement to ideas.
Regards,
Xiaoxin Sheng
Hi @suji,
Currently, power bi visuals not contain this feature, perhaps you can try to use below method which used to check if the table is empty.(IsEmpty function)
Measure:
IsEmpty = IF(ISEMPTY('test color'),"This table is empty","This table contains records")
Result:
In addition, you can also post this requirement to ideas.
Regards,
Xiaoxin Sheng
Is this solution also valid for a chart?
I have a chart that only displays no data with some slicers options, I would like to have the message displayed in this case.
I've created the measure:
IsEmpty = IF(ISEMPTY('sheet1'),"This table is empty")
I'm not sure if this is valid and where to added it on the chart.
Can, please, someone help me?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
96 | |
69 | |
45 | |
39 | |
30 |
User | Count |
---|---|
159 | |
98 | |
60 | |
42 | |
42 |