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.
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.
Solved! Go to 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.
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
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |