Forum Discussion

DTaraboletti's avatar
DTaraboletti
Helper I
2 years ago
Solved

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

 

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 

Need Help

4 Replies

    • DTaraboletti's avatar
      DTaraboletti
      Helper I
      2 years ago

      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.

      • DTaraboletti's avatar
        DTaraboletti
        Helper I
        2 years ago

        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.