topic Re: Creating Dynamic Slicers in Power BI Based on Column Selection in DAX Commands and Tips

Creating Dynamic Slicers in Power BI Based on Column Selection

Zaytoon — Mon, 26 Aug 2024 08:25:31 GMT

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.

Re: Creating Dynamic Slicers in Power BI Based on Column Selection

dharmendars007 — Mon, 26 Aug 2024 08:42:03 GMT

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

Re: Creating Dynamic Slicers in Power BI Based on Column Selection

Zaytoon — Mon, 26 Aug 2024 09:21:34 GMT

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

Re: Creating Dynamic Slicers in Power BI Based on Column Selection

xifeng_L — Mon, 26 Aug 2024 15:35:50 GMT

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~

Re: Creating Dynamic Slicers in Power BI Based on Column Selection

Zaytoon — Tue, 27 Aug 2024 07:44:25 GMT

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