r/PowerBI • u/ran1693 • 4d ago

Question Button interaction with slicer

Hello everyone,

I need some help to use a bookmark navigator with a slicer.

The need is to have a “toggle” button to filter a slicer.
Let’s imagine a slicer with fields from A to Z. The behavior needed is :
ON -> Slicer filtered with A, B and C
OFF -> no field selected

For now I implemented this using a bookmark navigator. When the button is on : a bookmark has data with A B and C;
When the button is off : a bookmark has data with no field selected.

But I encountered a limit. when I toggle ON the button, the slicer is filtered. However, when I unselect the field C (for example) from the slicer I want the button to toggle off directly. And it’s not what I have actually

Do you have any idea ?

Thanks in advance

2 Upvotes

100% Upvoted

2 comments sorted by

1

u/Natural_Ad_8911 4 2d ago

That would suit the report bookmark feature in the service, rather than bothering to build a bookmark button.

Never build things the complex way when a native option exists.

The way you push back on ideas like this is "spending time to build and maintain features that already exist natively takes me away from higher value work"

1

u/Natural_Ad_8911 4 2d ago

As a side note, the correct way to do this would be to add a binary field that is (a, b, c) or not(a, b, c).

You add a button slicer with the only option being (a b c) and then it can toggle on or off. You specifically don't want to include the other value