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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
DTaraboletti
Helper I
Helper I

Overlay report visuals based on data condition

I am trying to create an overlay (box) that covers all other Power BI report visuals whenever a specific data condition is met.

 

The use case for this is as follows:

 

1) Default behavior would be to display the report page as shown below

DTaraboletti_0-1694122449520.png

 

2) However, when a specific data-driven condition exists, in this case when the related project is on hold, and data refresh is suspended, I do not want people to be able to view the content as it would be stale and potentially misleading.  Under this condition, I would like to cover the content and display a message like shown below

DTaraboletti_1-1694122767782.png

3) The status of the project is maintained in a Sharepoint site and that list data is sync'd to the Power BI dataset... Thus, I would like to display the blue overlay, whenever the project status field equals "on hold"

 

Any help would be greatly appreciated.

 

Thanks in advance.

 

 

 

 

 

 

 

I've found various internet posts, but all seem to require user interaction with a data slicer to hide secondary/dependent visuals.  In my instance, I'm trying to cover all content whenever either an overall 

1 ACCEPTED SOLUTION
DTaraboletti
Helper I
Helper I

Based on continued research, it appears that the functionality required to support this use case is NOT currently available in PBI.  I've added a new "Idea" asking that the required functionality be added in future release.  Link to that idea provided below:

Ability to Show/Hide Card (and other visuals) based on data condition (https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=b8465c38-4252-ee11-a81c-6045bd7c1b6e)

View solution in original post

4 REPLIES 4
DTaraboletti
Helper I
Helper I

Based on continued research, it appears that the functionality required to support this use case is NOT currently available in PBI.  I've added a new "Idea" asking that the required functionality be added in future release.  Link to that idea provided below:

Ability to Show/Hide Card (and other visuals) based on data condition (https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=b8465c38-4252-ee11-a81c-6045bd7c1b6e)

amitchandak
Super User
Super User

@DTaraboletti , I think this approch should help

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks for the reply.  I had already reviewed that article and tried to make it work.   As i interpret that article, it requires user interaction with a slicer control to hide/show a separate visual.   What i'm trying to do is a little different.  I do not want user to interact with the solution.  I want Power BI to read the Project status field and automatically display the OVERLAY if the status is on hold (or similar inactive state).

 

I've already tried buttons, cards, measures, bookmarks, text box, shape objects in various combinations.

 

Text box and shapes lack the ability to associate a bookmark action

 

Cards lack ability to display the descriptive text, but can show the status

 

Buttons seem to require interaction 

 

Perhaps there's a combination that i've not thought of.

Update:

Using the referenced link provided by @amitchandak above 

(https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/)

 

I was successfully able to conditionalize a card based on the available status data value... So, the Card now provides a solid, opaque background when the project status is inactive and a transparent background when the project status is active.  

 

 

However, there's a problem with layering of the card...

 

When the project status is inactive, the opaque card needs to be the top layer so that users cannot see or interact with the report visuals.  But when the project status is active, the transparent card blocks ability for users to see and interact with visuals.   

 

I know that I could set a couple bookmarks to hide/show the Card object...but cannot find a way to apply these bookmarks dynamically based on the project status value.

 

Thus, I'm back to the original problem. 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

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.