Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
df123445
Helper II
Helper II

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 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

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

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.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

2 REPLIES 2
AnthNC
Helper II
Helper II

Hi @df123445,

 

Put the measure you're using for your visuals into the visual's filter pane and set your conditions :

AnthNC_0-1722485127297.png

 

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
Super User
Super User

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.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.