cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dharini Frequent Visitor
Frequent Visitor

Set slicer value based on selection of another slicer

Hi All,

 

I have two slicers , one slicer is region which is from Region master table 

 

 Untitled.png

 Another slicer which is from Test table and has same region field which has table level relation to Region master table 

And lists as below.

Untitled.png

If i select Region in master slicer( say Americas), then same(Americas) should automatically set in Region slicer which is from Test table .

Is this possible in slicer level. Kindly do needful.

 

Thanks

3 REPLIES 3
v-danhe-msft Super Contributor
Super Contributor

Re: Set slicer value based on selection of another slicer

Hi @Dharini,

Based on my test, if your two tables have relationship, it will automaticly filter to the select one:

Relationship:

1.PNG

Slicers:

1.PNG

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dharini Frequent Visitor
Frequent Visitor

Re: Set slicer value based on selection of another slicer

@v-danhe-msft Thanks for your reply.

 

I have requirement where selection in first slicer( from master table), should automically be selected in second slicer too(from test table).

 

For example ,if i select in first slicer(master) say first EMEA is selected and APJ is selected secondly as given below

Untitled1.png 

Here i have used chicklet slicer (with forced selection option) for second visual, so the first one EMEA selected in first slicer gets selected automatically (in green), but not the second one(in yellow). I want all the values to be selected in second slicer depending on first slicer selection.

Untitled2.png

 

 

Based on second visual values selected other visuals in report will change the data.

Is there any other slicers for enabling multiple options for above scenario.

Kinldy help me.

 

v-danhe-msft Super Contributor
Super Contributor

Re: Set slicer value based on selection of another slicer

Hi @Dharini,

Based on my test, I am afraid you could not achieve this feature currently, I suggest you submit an idea in ideas forum:

https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 123 members 1,542 guests
Please welcome our newest community members: