Forum Discussion
Creating Dynamic Slicers in Power BI Based on Column Selection
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.
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~
4 Replies
- xifeng_L
Super User
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~
- dharmendars007
Memorable Member
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
thanks dharmendars007 that helps in creating the first slicer, but the second one is still an issue?
