cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
akj2784
Post Partisan
Post Partisan

Hide Visualization with 0 record

Hi All,

 

I have a requirement to hide the visualization if nothing is returned based on the filter selected. Currently it is showing a blank report with only the column headers. 

Is there any way I can hide that ?

 

Regards,

Akash

5 REPLIES 5
v-yulgu-msft
Microsoft
Microsoft

Hi @akj2784,

 

Unfortunately, there is no such a visibility property to hide/show visiualization based on slicer selection.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ok.

It is is not possible to hide the visual. You could change the measure to return a space instead of blank in the event that there is nothing to return I guess

 

measure = if([measure]=blank()," ",[measure])



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Thank you for quick response.

I actually have 4 visualization, depending on the slicer value I want to enable the relevant visualization.

there is no out of box feature to implement that. Using IsFiltered and Selected, somehow I am able to show relevant data in the report. But the other 3 reports shows blank with just the header.

Is there any other way to show the report dynamically depending on my slicer value ?

Also, if I place 4 different reports, it will occupy that spcace and if there is nothing to show in any report, it will still occupy that space and show as blank which somehow I don't want. I am surpirsed to see Microsoft has not implemented such a basic functionality of Summary to detail navigation.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Kudoed Authors