Forum Discussion
Projecting Employee Retention
Hi I am looking to see if PowerBi has the capability to project future retention percentages based on previous 12 months retention. I am trying to forecast our employee retention rate for 2023. I'm n...
Yes its absolutely possible and easy.
The only caveat is that this can only be done on a single line chart - not the type that you have above.
1. Put your measure into single line chart -with a date formatted time column as the x-axis and your retention numbers as the y axis
2. In the visualisation analytics pane, chose the third icon (magnifying glass).
3. Second from last option - Forecast - turn on
Easy as that
Accept this as the solution if this is what you wanted
Thanks for your help. The problem I'm now having is that it will not allow me to turn forecast on. I try to change it from off and it won't turn on.