Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
JSnow
Frequent Visitor

How to handle No Results

I would like to know if there is a elegant way to handle a displaying a table that has no values to be shown when it's working as intended.  I want to communicate to the user of the report that the table is empty on purpose instead of having them wonder if the report is failing.  Somewhat similar to a "This page was intentionally left blank" message.

 

For example I have a table that shows details of events scheduled for future dates.  Some of the users of the report won't have any events scheduled so the resulting table is blank.  I would like to instead display a message "There are no upcoming events scheduled"

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

Hi @JSnow

With a blank dataset below

5.png

 

Create a measure

Measure = IF(ISEMPTY(Table1),"This page was intentionally left blank")

Then add this measure to a card visual

6.png

 

 

 

Best Regards

Maggie

Thank you for the response that is helpful to create something to place when there is no data to display.

 

I guess what I am more so looking for is how to hide the empty visual.  As with this solution if I overlay the card visual on top there is still headers shown with no data below.  Is there a setting to control a transparancy property using the measure or changing the visability of a visual some other way?

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.