Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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
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
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
Solved! Go to Solution.
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)
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)
@DTaraboletti , I think this approch should help
https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
71 | |
54 | |
38 | |
31 |
User | Count |
---|---|
71 | |
64 | |
62 | |
50 | |
46 |