I have a dataset in Power BI.
This dataset has data on:
- Employee Name (Column)
- Employee Seniority (Column)
- Employee Current Salary (Column)
- Employee Salary Increase Minimum Proposal % (Measure)
- Employee Salary Increase Maximum Proposal % (Measure)
To give you context (fictitious use case) I want to give my employees a salary increase based on the data.
I have already determined with measures what percentage this increase should be (based on the current salary).
I want to create a new measure called: Future Salary.
I would like to create a slicer where the minimum is 'Employee Salary Increase Minimum Proposal %' and the maximum is 'Employee Salary Increase Maximum Proposal %'. This slicer must determine the increase and 'future salary' must display this.
So suppose: Employee 'John'. Salary 2023 - $50,000 Employee Salary Increase Minimum Proposal % - 4% Employee Salary Increase Maximum Proposal % - 10%
I want you to have a slicer between 4%-10% and you can slide the slicer to determine how much increase you want indicates the current salary. So with a 4% increase you should see 'Future Salary' at $52,000.
Do you know the easiest way to achieve this in Power BI?