Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Any way to show/hide visuals depending on data?

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...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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.

AnthNC's avatar
AnthNC
Icon for Helper II rankHelper II
2 years ago

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"

 

🤙