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.
maruthisp
Super User
Super UserHi Kumar_0606,
I tried to implement the solution for you in the below attached pbix file. Please check it.
Creating a dynamic parameter with custom list of values.pbix
Please let me know if you have further questions.
If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks!
Best Regards,
Maruthi
Kumar_0606Thanks Maruthi.
I followed your steps and created a table and calculations however when I drag a simple table with Amount and a field the parameter is not filtering the data.
Is there any binding or am I missing something. Pl suggest