Forum Discussion
Creating a dynamic slicer
Hi StevenT ,
Do you want to select column names in Slicer1 and show values of selected column in Slicer2?
If so, please refer to the method in message 3, that may be what you want.
Best regards,
Mengmeng Li
Hi StevenT
If you're meaning to change the slicer header, you can conditionally format it using a measure that responds to the selected value of the Parameter Order column.
Slicer Title =
SWITCH ( SELECTEDVALUE ( Parameter[Parameter Order] ), 0, "Text", 1, "Text2" )
Actually I found a way to do it that didn't require much coding. Please take a look at this link and tell me what you think? It worked perfectly for me.
https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Power-BI-Power-BI-Create-Dynamic-Slicers-using-Field-Parameters/m-p/2960735
You lost me there. Weren't you already usnig field parameters as you said you created one and you just wanted the title/header in the second slicer to be dynamic?
Creating the title was easy. The challenge I was having is that I wanted to take slicer one, let the user change the slicer values, and whatever is changed in slicer one, changes the values in slicer two.
Hi StevenT ,
Do you want to select column names in Slicer1 and show values of selected column in Slicer2?
If so, please refer to the method in message 3, that may be what you want.
Best regards,
Mengmeng Li