Creating Dynamic Slicers in Power BI Based on Column Selection

[Zaytoon]

I have a table named Submission_Models with columns: Market, Finance Mapping, and HC.
I want to create two slicers in Power BI:

1. Column Slicer: This slicer will allow users to choose between columns Market and Finance Mapping from the Submission_Models table.
2. Value Slicer: This slicer will display the unique values from the column selected in the Column Slicer.

[xifeng_L · Accepted solution]

Hi @Zaytoon 

You can use Filed parameter.

Step1 : Add the columns that allow users to choose

Step2 : Use the parameter to create the first slicer.

Step3 : Copy the first slicer, and setting to "Show values of selected field"

By following the above steps, you can obtain the results you want.

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[Zaytoon]

Many Thanks @xifeng_L  that was exactly what i was looking for ! 👏

[Zaytoon]

thanks @dharmendars007 that helps in creating the first slicer, but the second one is still an issue?

[dharmendars007]

Hello @Zaytoon m 

You can create the Filed parameter to achieve the same...

Please find the video link which will be helpful in creating the same.

https://www.youtube.com/watch?v=-k58Clhk0Dk

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN