Forum Discussion
Generate two interacting What If Parameters
I want to generate two parameters where following conditions satisfy: max value 100 minimum value 0 If i select 70 from one slicer other should show range 0-30 only , that is 100-x. I wrote this ...
Can somebody please suggest a solution.
I really need this , it is very easily possible in Spotfire :(
Thanks for your help in advance
Regards
PowerBIUser
In case anyone else is struggling with this issue, I came up with a workaround.
I too couldn't find a way to set the max parameter2 value based on the selected value of parameter1, so instead I fixed the maximum selected value of the second parameter:
Parameter2 Value = MIN(SELECTEDVALUE('Parameter2[Parameter2], 0.1),1-Parameter1[Parameter1 Value])
I then added a Card visual next to the slicer showing the Parameter2 Value, which shows the overridden value.
Not perfect, but it does the job!