Forum Discussion

Joynul's avatar
Joynul
Frequent Visitor
2 years ago

Hide Card visual based on filters values

Hello, I'd appreciate it if someone could inform me whether this can be accomplished in Power BI. If it's feasible, could you kindly guide me on the steps to achieve it? If not, are there any alternative solutions available?

At present, I have the following visual representations:

 

I aim to implement a functionality where, upon selecting a category within the pie chart, the card displaying 49.41% is concealed, and a new card displaying an alternative calculation becomes visible.

 

I have already attempted to create a measure which contains the following Formula 

 

Hide Visual = IF(SELECTEDVALUE(Utilisation_Month[Request Type]) in {"Off Plan","Planned","Operational"},"1","0")
 
But I am unable to utilise this as I am unable to select anything within the filters 
 

I am also currently looking into the option to use bookmarks but again I am struggling to the the pie / donut chart to do an action when it's selected

Need Help

1 Reply

  • rubayatyasmin's avatar
    rubayatyasmin
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi, Joynul 

     

     

    Here is the step from gpt

     

    1. Setup: Overlay the two cards (49.41% and the alternative) on your report.
    2. Selection Pane: Use the Selection Pane from the View tab to toggle visual visibility.
    3. Bookmarks:
      • Save the default state with the 49.41% card visible as "DefaultState".
      • Hide the 49.41% card, show the alternative card, and save this as "CategorySelectedState".
    4. Link to Action:
      • Click on your pie chart, use the Format > Action card.
      • Set action to "Bookmark" and choose "CategorySelectedState" for the destination.
    5. Add a reset button or shape linked to "DefaultState" for users to return to the initial view.

    By using this method, selecting a pie chart segment will switch between the two cards.