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 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
4 Replies
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
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
