cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ianallen13
Regular Visitor

Predictive Forecasting Tool

Hello, 

 

I'm looking for some guidance on how to setup some sort of predictivite forecasting tool in Power-BI, however, what I want is something like the following: 

 

Data source - Excel file

 

I am looking for something where: 

Case-Type A: 57 minutes

Case-Type B: 26 minutes

Case-Type C: 20 minutes

etc... 

 

And I want to use sliding slicers where I can slide the incoming case volume up or down (i.e. 100 cases of A to now 200 cases of A per day, etc.), and it will tell me how many hours total I will need to work all these different case types total.  

 

How would I begin to set this up?  I wouldn't think it would be too hard, but I'm not sure?  Never tackled anything like this before... 

1 ACCEPTED SOLUTION
GilbertQ
Super User II
Super User II

Hi @ianallen13 

 

You can use the What-If parameters to achieve this with a slicer

 

Here are more details on how to get this working: Use what-if parameters to visualize variables - Power BI | Microsoft Docs





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

1 REPLY 1
GilbertQ
Super User II
Super User II

Hi @ianallen13 

 

You can use the What-If parameters to achieve this with a slicer

 

Here are more details on how to get this working: Use what-if parameters to visualize variables - Power BI | Microsoft Docs





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!