Hide Visualization with 0 record

[akj2784]

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

[v-yulgu-msft]

Hi @akj2784,

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

Regards,

Yuliana Gu

[akj2784]

ok.

[MattAllington]

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])

[akj2784]

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.

[akj2784]

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.