cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Community Support Team
Community Support Team

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.

 

Community Support Team
Community Support Team

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.