Any way to show/hide visuals depending on data?

[Anonymous]

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

[AnthNC]

Hi @Anonymous,

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"

🤙

[Ritaf1983 · Accepted solution]

Hi @Anonymous 

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.