cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TinyElephant
Helper II
Helper II

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?

 

Slicer Power BI.gif

1 ACCEPTED SOLUTION

Just found out I can use a Table or Matrix visual as a slicer which also responds back to other visuals.

View solution in original post

9 REPLIES 9
v-yalanwu-msft
Community Support
Community Support

Hi, @TinyElephant ;

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.

vyalanwumsft_0-1629339971886.png

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.

Just found out I can use a Table or Matrix visual as a slicer which also responds back to other visuals.

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.

 

Slicer Power BI.gif

Hi, @TinyElephant ;

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.

If it's not possible then I'd welcome any workaround to this.

I'm not experienced in Power BI but it should be clear to anyone that you're trying to visualize the data here and you're not going to use more redundant slicers for each visual in your already packed dashboard page just to see the other way around. 

amitchandak
Super User
Super User

@TinyElephant , 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



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

I have only one table for employee data.

@TinyElephant , then slicer should filter each other unless you stop then using interactions

 

from visual to slicer , try the measure filter approch

 



Power BI Features || Datamarts: https://youtu.be/8tskWsJTEpg || Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Time Intelligence Decoded : https://youtu.be/aU2aKbnHuWs&t=145s
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!
Dashboard of My Blogs !! Connect on Linkedin !! Subscribe to my youtube Channel !!
Want To Learn Power BI | Beginners !! Advance Concepts !! Power BI For Tableau User !!

Yeah. The only slicer (containing employee names list) I have is obviously filtering other visuals but I want other visuals to also filter the names in the slicer.

I don't understand the measure filter approach.

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors