Forum Discussion
Overlay report visuals based on data condition
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.