Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
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
@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
@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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
141 | |
120 | |
112 | |
60 | |
58 |