Negative Lower Bounds in Forecast in PowerBI

[jnlang]

Hello,

I am creating a data set and visualizing a forecast in PowerBI. All of my data is positive. However, when I go to model a forecast, I am getting a negative lower bounds instead of all positives.

Is there a way to make my lower bounds only be positive to get a more accurate look at a forecast?

TIA!

[lbendlin]

You would have to run your own forecast model to suppress the negative values.  With the multiple overlapping seasonalities in your data any forecasting model will struggle. How meaningful is the current result?

[jnlang]

The current result seems to be pretty on par with expectations, however the way it is displaying I feel is just hard to explain to others with the negative values displayed.

I am pretty much brand new to PowerBI and don't have much experience with data manipulation, so I am not quite sure how to run my own forecast model or make it more appeasing to look at.

[lbendlin]

I would recommend that for now you tell your business users that this is how forecasting works, and to simply ignore the negative part. Then read up on different forecasting models and run them yourself in a Python notebook or any other tool  (but not necessarily in Power BI).

[SamWiseOwl]

Hi @jnlang 

This won't change the forecast but if you set the Y-axis Minimum to 0 it will hide those values:

[jnlang]

Could I ask how you get your data grouped by year at the bottom? My data is across every day for the last 2 years, so as you can see in my image it is divvying them up by day. I think the data looks a lot more clean the way yours has it.

This is my current data set and how the date is set.

[v-heq-msft]

Hi @jnlang ,
Based on your description, if you want to use the year for grouped displays, then you can use a date hierarchy and put it on the y-axis of the line chart, and you can also drill down to get more granular date grouping results.

Auto date/time in Power BI Desktop - Power BI | Microsoft Learn
Drill mode in the Power BI service - Power BI | Microsoft Learn

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