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

Подписаться 10 тыс.

Просмотров 8 тыс.

50% 1

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
Check out our website www.powerbihelpline.com and blog-post. for end-to-end power BI solutions, Power BI templates, or any kind of Power BI questions like Power query errors, Authoring and optimizing DAX codes for complex business logic.
Follow us on LinkedIn
/ power-bi-helpline-22a2...
Email- info@pbihelpline.com
@PowerBIHelpline

Наука

Опубликовано:

3 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 31

@cosladacity1 9 месяцев назад

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

@PowerBIHelpline 9 месяцев назад

Glad to know this is so useful. Thank you so much for all the love and support to the channel.

@sadiqabkr 9 месяцев назад

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

@PowerBIHelpline 9 месяцев назад

Thank you so much for the feedback. trying our best to bring maximum from the real time Power BI Projects issues and its solutions.

@sadiqabkr 9 месяцев назад

Absolutely. Keep it up. We're glad to have such a channel.

@edwinarchico439 9 месяцев назад

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

@PowerBIHelpline 9 месяцев назад

Glad it was helpful!

@mnowako 3 месяца назад

Amaizing, thx!

@PowerBIHelpline 3 месяца назад

Thank you too!

@RakeshSaha1705 25 дней назад

nice concept

@PowerBIHelpline 22 дня назад

Glad, you liked it

@spilledgraphics 9 месяцев назад

AMAZING! 👏👏👏👏

@PowerBIHelpline 9 месяцев назад

Glad you like it!

@spilledgraphics 9 месяцев назад

@@PowerBIHelpline I think there's room for aesthetic improvements, yet the functional approach of this is fantastic!

@PowerBIHelpline 9 месяцев назад

Definitely there is always a room for improvements

@osamaaljaafari.6645 8 месяцев назад

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

@PowerBIHelpline 8 месяцев назад

Glad to know it is useful to you. To get the PBIX file used in the demo, you can send an email by mentioning the video title as email subject.

@osamaaljaafari.6645 8 месяцев назад

Thank you for interacting with us❤

@osamaaljaafari.6645 8 месяцев назад

@@PowerBIHelpline Hello, an email has been sent to your email address, and the name of the video has been written in the topic as you kindly did, but we did not receive anything

@PowerBIHelpline 8 месяцев назад

@@osamaaljaafari.6645 Please check if you have sent to the correct email ID which is info@pbihelpline.com. Try to resend it, as i couldn't find it in the inbox.

@Media_Advertising_Analytics 7 месяцев назад

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.

@PowerBIHelpline 7 месяцев назад

In Commulative Sales Measure replace the return statement with below - RETURN IF( SELECTEDVALUE(dim_Date[MonthNumber]) < _maxmonth, _cummulative ) and in the forecast replace the return statement with below- RETURN IF( SELECTEDVALUE(dim_Date[MonthNumber]) = _maxmonth-1, _cummulative, IF( SELECTEDVALUE(dim_Date[MonthNumber]) >= _maxmonth, DIVIDE(_cummulative, _maxmonth)* (SELECTEDVALUE(dim_Date[MonthNumber]) - _maxmonth) + _cummulative ) )

@GopherzHockey 5 месяцев назад

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.

@d-day5709 7 месяцев назад

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?

@PowerBIHelpline 7 месяцев назад

Yes you can use that as well. you need to take care of the month selection in the slicer. it should show only for future months from the slicer month selection.

@youleib2965 8 месяцев назад

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?

@PowerBIHelpline 8 месяцев назад

Calculating the correct cumulative value for each year is the hint . include VALUES(Date[Year]) inside your CALCCULATE().