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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
mkohli
Frequent Visitor

Dynamically change field used in a slicer

I am trying to find a way to dynamically change the field selected in a slicer based on the selection of another slicer. For example in the images below, if I select "Route" in the first slicer "Rows", then the second slcier on the right should show all possible options /categories under "Route".  And if I select Channel in the first slicer, then the second slicer should show all possible categories under Channel. (Route and Channel are both fields in my dataset)
This is slighltly different from using a dynamic field parameter since I want to change the categories displayed based on the selected field and not chnage the field itself.
Annotation 2024-09-26 141705.png
Annotation 2024-09-26 141531.png

3 REPLIES 3
v-mengmli-msft
Community Support
Community Support

Hi @mkohli ,

 

Thanks for @parry2k reply, that's really helpful!

 

@mkohliHere is an example for your reference.

 

You can try to build such a table and then put the two columns in each of the two slicers. If you don't want the slicer on the right to affect the slicer on the left, you can disable interaction.

vmengmlimsft_0-1727422308533.png

vmengmlimsft_1-1727422653463.png

 

 

 

Best regards,

Mengmeng Li

@v-mengmli-msft @parry2k Thanks for the help! I was able to create a table and the corresponding slicers. However my end goal is to use the slicers to filter a bigger table and for that I need to create relationship between the main table and the custom slicer table and I cannot figure out how to do that. For reference these are what the 2 tables look like. 

mkohli_0-1727467538639.png

Essentially I want to be able to first filter the custom slicer table on "Field" and then filter the Main table on the column corresponding to the Field but using the "Value" in the Field. 

For example - Filter Custom Slicer Table on Channel - then filter Main table on value A in the Channel Column

 

parry2k
Super User
Super User

@mkohli you need to make a table with all the combinations of channel and route and then use a column from this table in the slicer and that will take care of it.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.