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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Change Visual when filter is active

Hello, 

I'm trying to figure if it is possible to replace a certain visual with another one when a filter is activated, 

I have a card that displays a text from the dataset when a filter is active, I want to display a table when the filter is not activated,

 

Is it possible to do this ?

 

Thank you.

1 ACCEPTED SOLUTION

@Anonymous 

 

Sample file is attached for your reference.

https://drive.google.com/file/d/1TNFnuQ_G26Gf4l5voaDhJEy2It885tmu/view?usp=sharing

 

Regards

Kumail Raza

Did this help? Kudos are appreciated

Consider Accepting it as the solution to help the other members find it more quickly and I would love to see your like.

View solution in original post

5 REPLIES 5
Kumail
Post Prodigy
Post Prodigy

Hello @Anonymous 

 

You can do this with bookmarks and buttons;

- Add the visuals to canvas.

- Add button for each visual.

- Create bookmark for each visual.

- Link the bookmark to the button.

 

A sample file is attached for your reference.

https://drive.google.com/file/d/1sFfDDWtVuzruQtERFTD2dgbywJJA02S1/view?usp=sharing

 

Hope this helps.

 

Regards

Kumail Raza

Did this help? Kudos are appreciated

Anonymous
Not applicable

Hello Kumail, 

Does this require to change my slicer filter into buttons for each possible filter value, so that I can make an actions for each button to navigate between each bookmark ?

Hello @Anonymous 

 

Not necessary, you can create a measure to turn on/off the visual and put it in the slicer pane.

 

 

Measure = 
IF (
    SELECTEDVALUE ( Table2[Slicer] ) = "Show Visual 1",
    1,
    IF ( SELECTEDVALUE ( Table2[Slicer] ) = "Show Visual 2",
     2 )
)

 

 

Regards

Kumail Raza

Did this help? Kudos are appreciated

Consider Accepting it as the solution to help the other members find it more quickly and I would love to see your like.

Anonymous
Not applicable

Yes exactly, I'm trying to figure how to do the " Show Visual 1 ", I know how to manage this using buttons but not with a filter

@Anonymous 

 

Sample file is attached for your reference.

https://drive.google.com/file/d/1TNFnuQ_G26Gf4l5voaDhJEy2It885tmu/view?usp=sharing

 

Regards

Kumail Raza

Did this help? Kudos are appreciated

Consider Accepting it as the solution to help the other members find it more quickly and I would love to see your like.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.