Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi, I'm stuck and I think I might not even be using the right words to ask the question.
Basically what I am trying to do is a line level parameter that users can change, which results in updates to the dashboard.
The use case is a list of sales opportunities, which each have a % win chance. I would like users to be able to adjust the % win chance, and have the dashboard result in changes to the financial forecast figures. Each line would potentially have a different value for the parameter, so I don't think that I can use a parameter which has a global value - but I would love to be wrong!
Opportunity A, $100, 80% -----> 70%
Opportunity B, $100, 50% -----> 60%
Opportunity C, $100, 30% ------> 50%
Anticipated Revenue - Original: $160 -----> New: $180
Solved! Go to Solution.
Hi @Anonymous ,
Thanks for @lbendlin reply. There is an alternative you can try, only when the data is small
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:
Create three parameter
Parameter 1= GENERATESERIES(1, 2, 0.1)
Parameter 2 = GENERATESERIES(1, 2, 0.1)
Parameter 3 = GENERATESERIES(1, 2, 0.1)
Create a measure
Parameter Value =
IF(
SELECTEDVALUE('Table'[Opportunity]) = "Opportunity A",
SELECTEDVALUE('Table'[Value])*SELECTEDVALUE('Parameter 1'[Parameter]),
IF(
SELECTEDVALUE('Table'[Opportunity]) = "Opportunity B",
SELECTEDVALUE('Table'[Value])*SELECTEDVALUE('Parameter 2'[Parameter]),
IF(
SELECTEDVALUE('Table'[Opportunity]) = "Opportunity C",
SELECTEDVALUE('Table'[Value])*SELECTEDVALUE('Parameter 3'[Parameter])
)
)
)
Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Anonymous ,
Thanks for @lbendlin reply. There is an alternative you can try, only when the data is small
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:
Create three parameter
Parameter 1= GENERATESERIES(1, 2, 0.1)
Parameter 2 = GENERATESERIES(1, 2, 0.1)
Parameter 3 = GENERATESERIES(1, 2, 0.1)
Create a measure
Parameter Value =
IF(
SELECTEDVALUE('Table'[Opportunity]) = "Opportunity A",
SELECTEDVALUE('Table'[Value])*SELECTEDVALUE('Parameter 1'[Parameter]),
IF(
SELECTEDVALUE('Table'[Opportunity]) = "Opportunity B",
SELECTEDVALUE('Table'[Value])*SELECTEDVALUE('Parameter 2'[Parameter]),
IF(
SELECTEDVALUE('Table'[Opportunity]) = "Opportunity C",
SELECTEDVALUE('Table'[Value])*SELECTEDVALUE('Parameter 3'[Parameter])
)
)
)
Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks, I think that this would work for a list of a fixed length, but that isn't personally my use case.
I experimented with creating a table of all of the what-if scenarios by crossjoining a series with the list of opportunites, but ultimately was unable to find a way to make a slicer off of that which I found to be palatable to users.
CustomValuePerOpportunity = CROSSJOIN(GENERATESERIES(0,1,0.1), opportunities)
Are you looking for the "Numerical Parameters" aka "What-If parameters" ?
I think not, because the parameter would apply the same number to every line item in a table, and I want to operate line by line
So line 1 would be - 10, Line 2 would be +10, line 3 would be +20 if that makes sense
Great use case, not currently supported. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.