Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |