Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Joynul
Frequent Visitor

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:

Joynul_1-1696630137880.png

 

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 
 
Joynul_2-1696630235032.png

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

1 REPLY 1
rubayatyasmin
Super User
Super User

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.

 

rubayatyasmin_0-1689517080227.png


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors