Forum Discussion
Kumar_0606
Helper I
Helper ICreating a dynamic parameter with custom list of values
l am a Power BI Beginner, trying to create a dashboard which should filter data on the go. I imported data from SAP HANA and created a matrix table. My calculation is IF Steward = "Acc" then IF Acc...
Hi Kumar_0606 ,
please try below steps as what I did in the pbix file.
- Sample data lives in FactTable with columns Account, Indicator, Amount.
- StewardParam is a small disconnected table with two text values, used in a slicer.
- SelectedSteward measure grabs the user’s pick.
- StewardedAmount uses SWITCH + CALCULATE to run only the filter logic you want for each mode.
- No relationships to manage—just drop the slicer and the measure into your report.
Kumar_0606Helper I
Helper IThanks Maruthi.
I followed your steps in creating the table and calculations however when I drag simple table with Amount and field, the values are not getting changed in selecting the parameter values.
Am I missing something, pls suggest.
maruthisp
Super User
Super UserHi Kumar_0606 ,
please try below steps as what I did in the pbix file.
- Sample data lives in FactTable with columns Account, Indicator, Amount.
- StewardParam is a small disconnected table with two text values, used in a slicer.
- SelectedSteward measure grabs the user’s pick.
- StewardedAmount uses SWITCH + CALCULATE to run only the filter logic you want for each mode.
- No relationships to manage—just drop the slicer and the measure into your report.