Show Cumulative FORECAST and Actual on the Same Line | Power BI Line Chart Formatting

Showing a cumulative forecast based on the monthly average value of actual is tricky. And in this video I will show you how can you create with some DAX tricks and Dynamic Data label formatting.

Get Help into Questions Related to #powerbi, #dax, #powerquery Power BI #datamodeling, #analysisservices and #powerbiservice and #microsoftfabric

Follow us on LinkedIn
@PowerBIHelpline

[cosladacity]

incredible !! from now on ill built the forecast using this dax pattern on the fly.

thanks so much i love your content. i think defo you are one of the best in internet

[sadiqabkr]

Wonderful video with full of tenacity and analytical thinking. Great tricks. 👍 👍 👍

[edwinarchico]

Simple is more, been looking for this, very useful, i will apply this to my project. 😊😊😊

[mrgilmour]

Thanks for the video. Similar to how there is the “forecast” extension to the actuals, it would also be nice to see trend (sounds similar to forecast but in my world, the trend is different. Forecast is human input and can always be much higher). Also an extension or a whole different line for budget.

And a way to evaluate the forecast vs budget by + or - 1, 2, 4 percent

[osamaaljaafari.]

A very nice work for which we thank you please provide us with a work file so that we can benefit from it and review the arithmetic functions used

[GopherzHockey]

What is the difference between dim_date[Month] and dim_date[MonthNumber]? In my date table they are both numbers. It would be helpful to both see how your data looks and to see more of the screen so I can see how the visual is being created.

[Media_Advertising_Analytics]

Thanks for the great video. How would this be modified in order to only show cumulative historical values BEFORE the current month and then show forecasted values for the current month (projected full month) and future months? Thanks.

[youleib]

Thx for this nice input
Was implementing your Solution.
But it is Not Working with a Date Visual and a Date slicer filtering Over Few years 😢 u have a Hint?

[d-day]

Can the same result be achieved if I already have a measure for cumulative daily sales plus a predefined forecast and separate measure to calculate cumulative daily forecast?

[PrashantGeminiMaheshwari]

could you please share the dax measure or template you have used in this video

[guppi]

Great tips. But for beginners like me, the tutorial is little bit too fast to follow