Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Dharini
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

4 REPLIES 4
v-danhe-msft
Employee
Employee

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.

@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.

 

@Dharini 

Good sir your method of chicklet slicer was a major solution to my problem 

I thank you alot.

Great work and i really do hope u achieve what you are after.

Great regards sir.

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.