Creating a dynamic parameter with custom list of values

[Kumar_0606]

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 Account= "Accountable" then “ Amount” End
IF Steward= "Total" then IF Indicator IN ("F","L”) then “Amount” End End.

Steward is a parameter created in tableau with custom values "Acc" and "Total" not a direct field.

Any help would be highly appreciated

[Kumar_0606]

Thanks 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 · Accepted solution]

Hi @Kumar_0606 ,

 please try below steps as what I did in the pbix file.

1. Sample data lives in FactTable with columns Account, Indicator, Amount.
2. StewardParam is a small disconnected table with two text values, used in a slicer.
3. SelectedSteward measure grabs the user’s pick.
4. StewardedAmount uses SWITCH + CALCULATE to run only the filter logic you want for each mode.
5. No relationships to manage—just drop the slicer and the measure into your report.

[V-yubandi-msft]

Hi @Kumar_0606 ,

Thanks for reaching out to the Microsoft Fabric Community. Could you please review the PBIX file shared by @maruthisp  and confirm if it meets your requirements as expected?

If it doesn't fully meet your needs, kindly share a few more details about your requirements so we can assist you further..

Regards,

Yugandhar.

[maruthisp]

Hi 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 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X

[Kumar_0606]

Thanks 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 

[ryan_mayu]

@Kumar_0606 

could you pls provide some sample data and expected output?