Forum Discussion
Display "No data found' when visual is empty
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/2868882Hi 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.
Hi MikeGanem3,
Kindly provide sample data or an expected output to help us gain a clear understanding of your requirement and offer an appropriate solution.
Thank you for your cooperation.
Hi MikeGanem3,
I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.
Please let us know if there’s anything else we can do to help.
Thanks for connecting with the Microsoft Fabric Community Forum.