Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
76 | |
75 | |
46 | |
31 | |
27 |
User | Count |
---|---|
99 | |
91 | |
51 | |
48 | |
47 |