Actuals and Forecast as one Line in Power BI #Shorts

Show actuals and forecast as a connected line in Power BI in 1 Minute. Do you want to learn Power BI desktop? Are you a …

Actuals and Forecast as one Line in Power BI #Shorts/a>

you want to show actual and forecasted future values as a connected line but with different formatting then you need two measures one that returns the actual values for example sales actuals and you need a measure that returns the actual values for dates before the last sales date and forecasted values after first you need to find that last sales date which you can do with a max function as this returns the last sales date in the filter context you need to remove any filter on date using calculate and remove filters while you might think of using an if function this would return the wrong values if you want to show totals so instead you can use a calculate function and modify the filter by taking the dates in the filter context with the values function and then filled those to the dates after the last sales date a second alternative is to simply write your filter condition but wrap it in a keep filters function so that it doesn’t override the filter from the visual place the measure on a line chart and add the actual smasher below it on values