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.
I've tried it but it did not work.
I created a new excel file with the sheet name Sheet1 and a column name Region with first row as header. I then copied and pasted your code but it did not do anything and the column value still remained blank.
Also, I need the "No Data Found" if the entire table is empty and only has the header in the first row.
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:
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.
Thanks, but this is not what I was looking to do.
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.