What will the FUTURE bring?! Showing MULITPLE FORECASTS in one chart in Power BI

In this video I show you how to show multiple forecasts in one visual. This is very useful if you are in the forecasting process and you want to show different points view from multiple people or departments. Enjoy the video and subscribe for more Power BI hacks!

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
01:00 End result we are going to build
01:31 Combining the actuals with the remaining forecast with DAX
03:10 Toggle to show or hide the historical forecast
06:00 Adding the forecasts from different departments
08:42 Adding the actuals
14:35 Adjusting the formatting
15:47 Hide and show lines with a slicer
17:00 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[UlyssesHaq]

Bas, good sir and noble gentlemen... this is FIRE!!!🔥🔥 - It's as if the planets aligned for once and just as I was asking this question - you reveal yourself in a state of perfection! I was looking for a cleaner and less onerous solution than managing a mess of bookmarks, but this...this is MAJESTIC and elegant. I can't thank you enough.

[sukoi]

Bass, this was a Perfect example to create a impressive visual and a lot of control. Client likes it very much.
God bless you.

[BolajiBI]

Man, this a very creative interactive visualisation.

Great video! I love your visualisation magic.

[CJ-jctn]

Another brilliant video tutorial from Bas. Top quality video presentation, perfect speed so you don't have to continuously rewind and as always, a ton of DAX tips packed into one tutorial. Keep up the great work in 2022. Thank you for all the effort you clearly put into these videos.

[Tyraelxadrias]

Your videos are so useful! You explain what your achieving and explain it step by step on how to achieve it! Very well spoken clear and concise! Please keep posting videos like this and I'm sure you will get a lot more followers!

[laiqmehdi]

each of your video are informative every time I'm watching your video increase my skill best best ever all time most informative power bi learner

[velomikeproductions]

Love these videos yet its difficult to apply when you have a central semantic model which has been set up to prevent modifications. I am unable to add tables or use Power Query. Pretty much the only option is adding measures for everything! 😅

Great content and I recognize the amount of effort it takes for producing content. Another like from me. Appreciate you and those helping you!

[m.sajidtp]

And Power BI never looked so functional AND pretty! Awesome video again, you share a lot more than visualisation techniques. Top class channel and production too. 5/5 ✨

[ozGold]

Excellent video Bas! This sets a new benchmark of how actuals and forecast should be presented. Keep up the great work.

[ymohamed]

Great video. Can you please make us a video of how you calculated the forecast. Thanks

[workstuff]

I love the format of your content. Great explanation and editing. Thank you.

[kartik-wijv]

best content and presentation for visualization in power bi.. Thanks for sharing..

[mdhidayat]

Nice use of layers to display forecast and actual. Now we all can be The Watcher and ponder the question: what if?😀

[telesforosotelogalindo]

Thank you so much. I would like to change the line style of all departments at the same time for future data, it is possible to change the line style through DAX. The categories (departments) may vary over time.

[vv]

nice...but how to show the same (multiple forcasts) in terms of numerical values in the form of table rather than chart ..??

[alejandrojuarezrodriguez]

Thank you! Muchas gracias! Love how you explain it step by step and all your lessons feel so creative. 😄

[Delightforeyes]

If data for the department is in bulk, not in Excel, how do you recommend implementing it?
Also if for example, end-users need to print the name of the department, instead of selection. this functionality is not supported not by PBI, what language/tool is best to implement it on top of PBI?

[dpecoraro]

Bos. This is so helpful! I am currently learning Power BI and I need to do something nearly identical to what you showed. Question: I saw tht you had other measures but I was unable to see the format on those (Sales Actuals and Sales Forecast). Perhaps they are listed on other videos. I will keep looking. :)

[frankgovers]

Ha Bas, very nice explanation.

Question, why do you use in your calendar calendarauto in combination with VAR MinYear = YEAR(MIN(fctActuals[Month]))
VAR MaxYear = YEAR(MAX(fctActuals[Month])) ????
these two have no influence??

I never use calendar auto, but a calendar with these settings

VAR BaseCalendar =

CALENDAR

[krishnavenkataraman]

Do you have a way to get the forecast values in a table format?