Dynamically change field used in a slicer

[mkohli]

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.

[v-mengmli-msft]

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.

Best regards,

Mengmeng Li

[mkohli]

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

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]

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