Hi!
Currently I'm trying to have 3 slicers, with 2 of the slicers dependant on eachother. What do I mean by this?
Let's say we have 3 parameters:
- Target revenue per month (amount of revenue generated)
- Target effort per month (amount of hours worked to generate said revenue)
- Target revenue per effort per month (amount of revenue per hour worked)
I'd like for 2 of these parameters to affect eachother where the user would input 'Target revenue per month' and 'Target effort per month' and automatically 'Target revenue per effort per month' is calculated.
But, at the same time I'd like it to be possible for a user to input 'Target revenue per month' and 'Target revenue per effort per month' and automatically 'Target effort per month' is calculated.
Essentially, I want to use these 3 parameters in my dashboard/report but have the user decide whether to put in the numbers for 'Target effort per month' OR 'Target revenue per month' whilst still showing the same visuals.
Is this possible? If yes, how would one go about achieving this?
Cheers,
Casper W.
