Dynamic Calculation for Scatterplot - % as a Slicer

[Anonymous]

Hi, 

Just looking to get some assistance with the below; I've gone through the chat but haven't managed to find a solution.

I would like to have a slicer for the Bonus % column below (which can be any % between 1 & 100%) without having to write separate DAX or calculations for each percentage. The % Bonus will be the same for all employees (does not need to be dynamic for each individual employee).

The Total Remuneration column will then be used as a field for a Scatterplot, with the entries moving on the plot as the Bonus % changes (hence the need for a dyamic calculation).

Any assistance is greatly appreciated!

[vicky_ · Accepted solution]

You could solve this by using a What-If parameter to represent the %, then use that parameter in your calculation. Check this page out: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if

[Anonymous]

Unreal Vicky - thanks for this!