cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Support
Community Support

Re: How to handle No Results

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

Highlighted
Frequent Visitor

Re: How to handle No Results

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
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors