Anyway to allow end users to enter a value for a calculation?

[GunnerJ]

I have a calculation that relies on a value that changes monthly. It's something thats managed by hand so I'm hoping there's a way to allow end users to type in the value to get the answer they want. Any solutions or ideas?

Thanks

[kentyler · Accepted solution]

Query parameters are probably what you are looking for. This post gives a really clear explanation of what they are and how they work, complete with lots of examples.

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

[amitchandak · Accepted solution]

If it is number. Create a what-if parameter. It is under the modeling tab.

You can create a slicer on that and change value.

[kentyler · Accepted solution]

Query parameters are probably what you are looking for. This post gives a really clear explanation of what they are and how they work, complete with lots of examples.

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/