Forum Discussion
Slicer responding to other visuals
Hello,
I was wondering if you can have a slicer in a dashboard that also responds back to other visuals.
For example, you have an "employee data" dashboard with Employee Names in a slicer list. Other visuals may be Departments, Job Role, Work Region etc. Is it possible to select, say, a specific department in a Donut Chart and have the Employees in the slicer list filtered down for that specific department? If not what's the alternate way to achieve this?
9 Replies
v-yalanwu-msftCommunity Support
Hi, Anonymous ;
If each person corresponds to an independent department, the department can also be used as a slicer, or multiple Slicer can be used to filter the person, like use Departments and Work Region slicer to filter.
So can you share some scenarios and simple data to better illustrate your problem？
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.As can be seen in your sample, I the Employee Names slicer is filtering other visuals. But I also want other visuals to have the ability to filter the Names in the slicer.
E.g. Clicking on "Department A" in the Donut Chart should reflect only Amy, Helen, and Peter in the slicer. OR Clicking on the US region should reflect only the employees working in that region.- v-yalanwu-msft
Hi, Anonymous ;
It's not clear why you're doing this, but slicer currently doesn't support this functionality.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- amitchandak
Super User
Anonymous , if you filter slicer from visual. try one of the 2 ways
1) Use bi-directional relationship between tables
2) Use a measure from common fact as a filter in Visual level filter, and check measure value is not blank
- amitchandak
Anonymous , then slicer should filter each other unless you stop then using interactions
from visual to slicer , try the measure filter approch
