Interactive Calculator

[aflintdepm]

I'm not sure if this is possible, but I would like to create a visualization that changes based on a value entered by a user so they can model different options.

For example, I have a visual that shows project productivity of a team based on a headcount of X employees.  If the manager wanted to add or subtract headcount, I want to give them a box that could then update the calculations for the new productivity.

Is this possible, and if so, how?

[Nain1122]

Yes, this is definitely possible. You can use parameter inputs or what-if analysis features in tools like Excel, Power BI, Tableau, or Google Sheets to let users change a value (like headcount) and instantly update productivity calculations and charts.

I recently built something similar for dosage and conversion modeling in a peptide calculator tool, where users adjust values and the calculations update automatically in real time. The same logic works well for workforce and productivity planning too.

[ppm1 · Accepted solution]

Please take a look at What-If parameters to do that.

Use parameters to visualize variables - Power BI | Microsoft Learn

Pat

[aflintdepm]

Thank you, @ppm1  This gave me a workable solution