Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Line Level Parameters?

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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:

vheqmsft_0-1715322337871.png

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

vheqmsft_1-1715322450906.png

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

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

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:

vheqmsft_0-1715322337871.png

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

vheqmsft_1-1715322450906.png

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

Anonymous
Not applicable

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)

lbendlin
Super User
Super User

Are you looking for the "Numerical Parameters"  aka "What-If parameters" ?

Anonymous
Not applicable

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

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.