User Input Factor Table

Madi — Sun, 31 Jul 2022 21:04:23 GMT

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

Re: User Input Factor Table

Hariharan_R — Tue, 02 Aug 2022 05:47:00 GMT

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

topic User Input Factor Table in Developer

User Input Factor Table

Re: User Input Factor Table