Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have some visual elements that I would like to hide when no data is available for them (tables, cards, etc..)
The only solution I've found online is to place a transparent block on top of them and to set the transparency (either 0 or 100%)
depending on a measure value.
That's great and it works, the only (big) problem is that even when the visuals are shown they are covered by an invisible block, so, for example, scrolling bars are not usable.
Is there any way to hide/show a specific visual that doesn't involve placing something on top of it?
TIA
Solved! Go to Solution.
Hi @df123445
Unfortunately, there is no option other than what you mentioned to hide visualizations.
Indeed, what can be done is either to hide with another object, and then there is a problem with interactivity because the object is "above" the visual.
Or, to manipulate the values and leave the visuals but instead of the values showing some message based on condition, or to add buttons and toggle/hide visualizations based on clicking a button.
There is an idea about this issue, please vote for it here :
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=d29f1752-8129-4f50-af85-d336da28cac1
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @df123445,
Put the measure you're using for your visuals into the visual's filter pane and set your conditions :
Let's say for example you want to hide a visual if your sales are < $1000.
Your measure would be "Total_Sales = SUM(table[sales_amount])"
Put this measure into the visual's filter pane and select in the drop down list "is superior or equal to" $1000.
In your case, and depending on your measure, you can select "is not null"
🤙
Hi @df123445
Unfortunately, there is no option other than what you mentioned to hide visualizations.
Indeed, what can be done is either to hide with another object, and then there is a problem with interactivity because the object is "above" the visual.
Or, to manipulate the values and leave the visuals but instead of the values showing some message based on condition, or to add buttons and toggle/hide visualizations based on clicking a button.
There is an idea about this issue, please vote for it here :
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=d29f1752-8129-4f50-af85-d336da28cac1
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
User | Count |
---|---|
84 | |
79 | |
71 | |
48 | |
43 |
User | Count |
---|---|
111 | |
54 | |
50 | |
40 | |
40 |