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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Powerlearn_95
Frequent Visitor

Parameter Multiplier Forecast Model in BI

Hi,

 

I am working with a report containing student data. Some of the students have graduated, some are still pending graduation. The pending students are reflected in a column titled "Anticipated Completion". This column counts all students that are expected to graduate. I am trying to build a forecast slicer that would give the end user the ability to calculate number of students who actually graduate if we expect 100% of anticipated completions to graduate, vs 80%, etc. I've used a parameter with a numeric value but the end user doesn't really see it. I've set a parameter "Anticipated Completion projection" to 100, which means that we expect 100% of all the students in the "Anticipated Completion" column to graduate. Is there a way to make this dynamic? And have the "Anticipated Completion" column values update as this number updates (currently I created another column that calculates the value in "Anticipated completion" * "Anticipated Completion projection" parameter/100? Also, can I somehow make this visible to the end user? Thank you so much for all the help!

1 ACCEPTED SOLUTION
swikritee_p
Resolver II
Resolver II

You can try using numeric parameters. Please refer to attached video for reference.

 

Parameter/What if Parameter: https://youtu.be/OB2ta2zEhl8

View solution in original post

3 REPLIES 3
swikritee_p
Resolver II
Resolver II

You can try using numeric parameters. Please refer to attached video for reference.

 

Parameter/What if Parameter: https://youtu.be/OB2ta2zEhl8

Wow, thank you so much! This will get me the result I'm looking for

Ashish_Mathur
Super User
Super User

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.