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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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