Forum Discussion
Allowing Dynamic user inputs on a Power BI dashboard
Hi DavidCather ,
I think you can set parameters.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
Users can change the parameters and get dynamic value.
You may also check about the document about Pin live page feature if you want it worked in dashboard.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-live-tile-from-report
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey, hopefully this explains the problem in more detail. I have a table of all the staff in the company.
Supply Table
| Name | Date of birth | Firmwide Retirement | Retirement Date | Role |
| John Smith | 01/05/1960 | 65 | 30/04/2025 | Project Manager |
| Jane Bloggs | 23/04/1986 | 65 | 22/04/2051 | Engineer |
And a table of all Projects that the company needs to staff.
Demand Table
| Project | Start Date | End Date | Project Managers Required | Engineers Required |
| Project ABC | 01/04/2021 | 31/12/2024 | 3 | 24 |
| Project ZYX | 01/11/2020 | 30/04/2027 | 7 | 32 |
Extrapolating the supply forward, I will have a view of the total available staff theoretically available in each year. I can then compare this to the Demand table and show whether there is projected to be an over or undersupply of staff to fulfil project roles. This allow a gap analysis like this to be plotted
Now the challenging part, I want to allow the user to change variables in the dashboard and see the effect this will have on supply, so I would like to have an input slider to change the retirement age, this number will need to be used to recalculate the retirement age of the staff member. And that in turn will affect the calculation of whether they are available or not on a certain date in the future. I'm open to suggestions as to how this can be achieved, I've been looking at the problem long enough now to see that it needs to be a workaround.
Thanks.
Hi DavidCather ,
I think you can set parameters.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
Users can change the parameters and get dynamic value.
You may also check about the document about Pin live page feature if you want it worked in dashboard.
https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-live-tile-from-report
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.