Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hi @akj2784,
Unfortunately, there is no such a visibility property to hide/show visiualization based on slicer selection.
Regards,
Yuliana Gu
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])
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.
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |