Forum Discussion
Interactive Calculator
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?
Please take a look at What-If parameters to do that.
Use parameters to visualize variables - Power BI | Microsoft Learn
Pat
3 Replies
Please take a look at What-If parameters to do that.
Use parameters to visualize variables - Power BI | Microsoft Learn
Pat
Thank you, ppm1 This gave me a workable solution
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.
