Forum Discussion
Display "No data found' when visual is empty
- 1 year ago
Please refer community post (have sample pbix file as well)
https://community.fabric.microsoft.com/t5/Desktop/need-to-display-message-when-there-is-no-data/td-p/1998322
https://community.fabric.microsoft.com/t5/Desktop/Want-to-Display-quot-No-Data-Available-quot-message-in-card-if/td-p/2868882 - 1 year ago
Hi MikeGanem3,
Thanks for using Microsoft Fabric Community Forum.
I tested the scenario using sample data and successfully implemented the solution.
To achieve this, I used Table and Card visuals with the following measures:
Table visual Measure:NoDataNames =IF(COUNTBLANK('Table'[names]) = COUNTROWS('Table'),"No data found",SELECTEDVALUE('Table'[names]))Card visual Measure:
NoDataMessage =IF(COUNTBLANK('Table'[names]) = COUNTROWS('Table'),"No data found","")Additionally, I have included the PBIX file that I created using the provided sample data. Kindly review it and confirm whether it aligns with your expectations.
If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!
Regards,
Sahasra.
Please refer community post (have sample pbix file as well)
https://community.fabric.microsoft.com/t5/Desktop/need-to-display-message-when-there-is-no-data/td-p/1998322
https://community.fabric.microsoft.com/t5/Desktop/Want-to-Display-quot-No-Data-Available-quot-message-in-card-if/td-p/2868882
- MikeGanem31 year agoHelper I
That is not what I am looking for...
I need the "No Data Found" if the entire table is empty and only has the header in the first row.