Forum Discussion
Change slicer options based on visual selection
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
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.
4 Replies
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).
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
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.Hi, Anonymous!
Yes, that's not a bad idea, I will probably do something of the kind.Thanks a lot,
Maria
