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.
Is there a way to have a button that will turn on/off filter(s) on a specific visual? What I'm stuck doing now is creating multiple tabs that have certain filters applied, but that seems clunky. I'd like the user to have a slicer on the filter for a visual, not the values of the field itsef if that makes sense?
Thanks!
Below is the way around I found:
Use combination of Bookmark and Button.
Create two bookmarks - 1 with filter on and another with filter off.
Create two buttons with action type as Bookmark and assign 1 bookmark for each.
You can now switch the view based on these buttons.
You can add a new column with the conditions you want (like YES and NO) and add a new visualization called ChicletSlicer. Then you need to direct your new column to that visual and you will only see two options in your visual that will filter according to your conditions.
Hi @Anonymous,
Unfortunately, there is no such an functionality that allows us to add a separate button to turn on/off slicer filters for specific visual.
Regards,
Yuliana Gu
If I am understanding you correctly, you want to disable the interaction between the visuals (i.e. you don't want one visual to filter another visual)
If that is the case, you can do so
In the Desktop, select the visual in question, select the Format tab, then select "Edit interactions", then for each of the other visuals, hover over them and select the None icon on the top right for that visual
Repeat for each visual turning off the interactions
Then you may have to republish your report
There may be a way to edit this directly in the service, but I haven't done that
Hope this helps,
What I'm trying to accomplish is have a visual set up that initially shows select filters. Then, have a button somewhere that a user can click that uses the same visual, but deselects the original filters and applies a new set. Basically, switching the filters without creating multiple tabs for different scenarios that use the same type of visual.
Oh, got it
I don't know of a way
Maybe the new bookmarking feature would be able to accomplish this, but I haven't done any work with them yet
Maybe others have experience
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |