Generate two interacting What If Parameters

[Anonymous]

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 expression using What if parameters.It has no syntax errors but does not do anything either.

Parameter2 = GENERATESERIES(0, 100-SELECTEDVALUE(Parameter[Parameter]), 1)

Any suggestions?

Regards

PowerBIUser

[v-piga-msft]

Hi @Anonymous，

By my test, if you want to reference the two parameters each oter, it seems that it will not work.

I suggest you could create one what if parameter x and then creata a measure with 100-'x'[x].

If you need further help, please share some sample data and your desired output, so that we can help further investigate on it?

Reference：Using the new "What-If" Interface for Power BI

Best Regards，

Cherry

[Anonymous]

Hi Cherry,

Thanks for your help 🙂

Slicer 1=0-100

Slicer 2=100-(value selected in slicer 1)

Since i want both the parameters to generate range and i want to show it as list of values available for the user to select , creating one parameter and one measure will not help.Measure cannot be put on slicer.

Right now i am trying to generate series for which data does not exist already. But i dont mind importing 1-100 list of values from an excel if in case we dont want to use generate series function and create some calculated columns that might help.

Thanks

[Anonymous]

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

[acstrange]

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!