Forum Discussion
Seeking Help about Power BI Line Chart & Forecasting Options
Super Userbut then another problem arise which is sales amount is showing for the upcoming days. You lost me on this one. How is that a problem?
But when i change the year from 2024 to 2023 by using the year filter option, then again it is also generating forecast for the year 2023The forecasting function has no idea what "2024" or "2023" means, All it does is look at the data you give it and then apply its algorithm. It's actually cute to see that the forecast closely matches the actuals.
About problem 1 : the scenario is there is no data in the excel file for the date range 27 Aug to 31 Aug 2024. When i use that column in Power BI as "Sum of Sales", those date range sales total showing as "0" in the line chart. Now, i am manupulating the excel file like this way- " if the day total is >0, then it will show the total amount of that day, else it will kept as " " (blank) for that day. When i implay that logic in the excel file for the rest of the days, it is perfectly working in the line chart for the previous days data like 3/10/17 Aug where there is no sales for the day & "0" sales day skipped in the line chart. But for the future / upcoming days, it is showing sum of sales in a flat line where actually the excel file contains the data as " ". I hope you are clear now.
about problem 2 : forecast means prediction of future, not about the past mate. If forecast options consider the data of past times, then what is the meaning of using it? It should only showing the forecast about the upcoming days, not for the days which is backdated from the present dates. I thought there might be a way around to resolve this.
- lbendlin
note that " " is not the same as BLANK(). Your source data really needs to have Nulls, not single space strings.
"forecasting is hard, especially the future". Don't use that feature for past dates then.