Change slicer options based on visual selection

[mtomova]

Hi all,

I have a slicer with few client codes.

What I want is - when I select a specific data in a visual, which relates to only one of the client codes, to see only this client code left in the slicer when I open it.

Is that even possible?

Obvisouly the visuals are affected by slicer selections, but I thought the other way around should work too?

Thanks,

Maria

[v-fenling-msft · Accepted solution]

Hi, @mtomova 

I am glad to help you.

The feature you mention is really not a standard feature of Power BI. The slicer is typically used to filter visual objects, not the other way around.

But if you just want to display the client code selected in the visual, perhaps you could add a Table visual and have it display the client code exclusively:

I've attached the pbix file for the simple example below, I hope it helps.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mtomova]

Hi, @v-fenling-msft!
Yes, that's not a bad idea, I will probably do something of the kind.

Thanks a lot,

Maria

[mtomova]

Hi, 

in the scheme the relationship the 'cross-fitler direction' is set to 'both'.
So I would have expected for these tables to fitler eachother.

As I test, I have created a visual and a slicer from the same table, and when I make a selection in the visual the slicer is not affected at all.

So I am wondering, if what I am after is even possible.

Thanks,

Maria

[audreygerred]

Do you have a star-schema? When you look at the model view and see teh joins between your tables, the arrows will point in teh direction of the filtering (what you will typically see if the arrow pointing in the direction of your fact table, i.e. the dimension table filters the fact table, not reverse).