User Input Factor Table

[Madi]

Hi,
Need help to add an input table to the report where clients can chose and apply the below % factor to total sales based on their band and Location. Ideally, input should be a drop down list of .01 to 1 to each cell; but if that is not possible an editable table would also do.   

 

Thanks

[Hariharan_R]

Hi @Madi 

Use what-if paramater (numeric range). You can create 4 different parameters and use the parameter values in the measures.

Ref - https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin