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.
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.
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!
each of your video are informative every time I'm watching your video increase my skill best best ever all time most informative channel.......for power bi learner
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!
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 ✨
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.
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. :)
Great tutorial Bas. I managed to create one before, but just now after I updated Power BI I tried to create another one but the forecasted value got all aggregated into one line. Can anyone please confirm this? Many thanks
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 (DATE(YEAR(FIRSTDATE(Verkopen[Orderdatum]));1;1);DATE(YEAR(LASTDATE(Verkopen[BetaalDatum]));12;31))
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?
Excellent work Bas, I made a slightly different version based on your previous (actual vs forecast on one line) video. Great job If you feel like making a Gantt chart /bar chart where I can track several projects with more than just a start /end date plus a constant line for today , I am sure many of us would be delighted
Hi Bash Hope you are.doing good & healthy with your family. Again with amazing video very useful video and very practical need everyone for every project ......very big thanks to share with us. If it can possible can you plzz provide us excel data file which you used. Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
Bas, I am forexasting in excel and all works fine, how come I cannot do the same in PBI? I am working specifically with weekly variables foe spring, summer, and fall college terms. I am completely stuck. Much appreciated.
this is perfect for what i need right now in my job, but 1 question, how did you format your x-axis(date) to look like that, either with date heirachy or using a calculated column I can never get it to have year below then quarter than month. how?
Can you please make a End to end project on Healthcare domain.... Like Data modelling, data transformation, data query, and powerbi and dax.... Minimum 1 hours And if it is unplugged its okkk... No need to work on editing or any changes...
You are wrong. I do actually look into a crystal bar during my forecasting efforts, and has a team we all chant the sacred songs. If the gods accepts our words as true a spreadsheet will appear, blessing us with their wisdom.
I need help from the community of power BI to create a formula in M code who can help me? // the task is as follow I need to find a Purchase order, that is in a long string (long text). lets say that text is in Column1, the new column must tell me the PO number or say "NO PO", // The conditios are as follow, the PO alwas start with a "2", it has 8 characters in total, it could any ware in the text, because Column1 is text i thing you must compare each of the 7 character after the first "2" with a list from 0-9, it is posible that in the text are many characters "2", so the code must check all the characters in the full text, find the first "2" check the other 7 charactes, if they are not alligen with the conditios, go to the next "2" in the text until finish analizing all the characters in the text string. sometimes you will find a line of more than 8 numbers after the "2" so keep in mind that the 9th character ( 2_______9th) could not be a number). Example: "RO21345678SomeRandomText" PO=21345678. Ejample2: "RO2314567890SomeRandomeText" PO="NO-PO" Because 2314567890 it start with "2" but the 9th character is also a number. Ejample3: "SomerandomeText21345678" PO=21345678 , The code must have into consideration that the PO could be at the end of the text string, so the 9th character could not be (null character is diferente than {"0","1","2","3","4","5","6","7","8","9"} I have been trying to solve this without any luck, it is time to ask for help, thank you guys in advance.
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.
hahaha lol thx Imran! 😄 too much credit 😊 - will try to make those planets align again in the next video 😉
Bass, this was a Perfect example to create a impressive visual and a lot of control. Client likes it very much.
God bless you.
Thank you very much Rajneesh! Happy to hear you can use it!
Man, this a very creative interactive visualisation.
Great video! I love your visualisation magic.
thank you Bolaji!!! 😊😀
@@HowtoPowerBI how to remember code
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.
hey C J, glad to see you here and thank you the generous words! yep, 2022 is THE year :) all the best to you!
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!
each of your video are informative every time I'm watching your video increase my skill best best ever all time most informative channel.......for power bi learner
Nice use of layers to display forecast and actual. Now we all can be The Watcher and ponder the question: what if?😀
thank you!!! 😀 haha indeed
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!
so nice to hear Michael 😀!!! thanks for the kind words!
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 ✨
Excellent video Bas! This sets a new benchmark of how actuals and forecast should be presented. Keep up the great work.
Great video. Can you please make us a video of how you calculated the forecast. Thanks
Always......The best content and presentation for visualization in power bi.. Thanks for sharing..
So nice of you, thx Bala! 😀
I love the format of your content. Great explanation and editing. Thank you.
Glad you like them! thank you!! 😊😀
Thank you! Muchas gracias! Love how you explain it step by step and all your lessons feel so creative. 😄
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.
Very Happy to see this Idea sir....pls guide us more and happy to learn with sir.....awsm man✌️✌️
thx Pramod! 😊 👊😎
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. :)
Thank you very much Bas, very good work, it facilitates the visualizations and allows innovating in the dashboards, continue like this, greetings.
so nice to hear, thx Marcelo!!!! 😀😊
Hi, Thank you! This is fantastic 🙂
Can you make a video on Showing actuals and future forecast for different departments in same line chart
Really great , i just wondering how we can apply this in real data 😊
Hi Bas, phenomenal video and solution, any idea why I cannot leverage the time intelligence functions
You are a very good teacher.
Thank you! 😃
This is pure Gold ❤❤❤❤
thanks!
Awesome 👍
nice...but how to show the same (multiple forcasts) in terms of numerical values in the form of table rather than chart ..??
Do you have a way to get the forecast values in a table format?
Hello! Can you explane how you calculate the forecast? What inside total revforecast measure inside? Thank you!
you can check the file (download link in the description)
Great as always Bas. Will the disconnected table work if a live connection report is created from this dataset?
Great tutorial Bas. I managed to create one before, but just now after I updated Power BI I tried to create another one but the forecasted value got all aggregated into one line. Can anyone please confirm this? Many thanks
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 (DATE(YEAR(FIRSTDATE(Verkopen[Orderdatum]));1;1);DATE(YEAR(LASTDATE(Verkopen[BetaalDatum]));12;31))
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?
This is awesome
Excellent work Bas, I made a slightly different version based on your previous (actual vs forecast on one line) video. Great job
If you feel like making a Gantt chart /bar chart where I can track several projects with more than just a start /end date plus a constant line for today , I am sure many of us would be delighted
ah nice that you could use it!!! 😀 thx for the idea - will look into it!
I did not have date column I will do forecasting that possible?
Cheers!!!!
Hi Bash
Hope you are.doing good & healthy with your family.
Again with amazing video
very useful video and very practical need everyone for every project ......very big thanks to share with us.
If it can possible can you plzz provide us excel data file which you used.
Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
thank you Ashish for watching again! I'm always doing fine 😎😉 hope you r 2!
how to create a table for forecast from the exiting data?
Bas if we have actual sales only then how do we find the forecast value ....
super...!!!!!!
Bas, I am forexasting in excel and all works fine, how come I cannot do the same in PBI? I am working specifically with weekly variables foe spring, summer, and fall college terms. I am completely stuck. Much appreciated.
this is perfect for what i need right now in my job, but 1 question, how did you format your x-axis(date) to look like that, either with date heirachy or using a calculated column I can never get it to have year below then quarter than month. how?
You can put the hierachy on the axis and turn concatenate labels off
@@HowtoPowerBI oh you absolute legend, i'll be doing that this morning :-) thankyou
Thanks soo much
thx for watching Yves
Marketing overshooting their forecast is a nice touch of realism here 🤣
😅 haha never noticed
Hi there! none of the links you shared above work. I don't think you attached the full link
Link for what
Amazing Sir...fantastic job!
Many thanks! 👊😎
do you have a Top N + Others
not yet - next video is gonna be about some other TopN stuff though 😄
Can you please make a End to end project on Healthcare domain....
Like Data modelling, data transformation, data query, and powerbi and dax....
Minimum 1 hours
And if it is unplugged its okkk... No need to work on editing or any changes...
Or any other domain...
But keep different domains in queue
Otherwise take a survey from subscribers that they want video in editing mode or not
Can I? 😅
@@bkgulshan yes yes sure....😉
You are wrong. I do actually look into a crystal bar during my forecasting efforts, and has a team we all chant the sacred songs. If the gods accepts our words as true a spreadsheet will appear, blessing us with their wisdom.
I need help from the community of power BI to create a formula in M code who can help me? // the task is as follow I need to find a Purchase order, that is in a long string (long text). lets say that text is in Column1, the new column must tell me the PO number or say "NO PO", // The conditios are as follow, the PO alwas start with a "2", it has 8 characters in total, it could any ware in the text, because Column1 is text i thing you must compare each of the 7 character after the first "2" with a list from 0-9, it is posible that in the text are many characters "2", so the code must check all the characters in the full text, find the first "2" check the other 7 charactes, if they are not alligen with the conditios, go to the next "2" in the text until finish analizing all the characters in the text string. sometimes you will find a line of more than 8 numbers after the "2" so keep in mind that the 9th character ( 2_______9th) could not be a number). Example: "RO21345678SomeRandomText" PO=21345678. Ejample2: "RO2314567890SomeRandomeText" PO="NO-PO" Because 2314567890 it start with "2" but the 9th character is also a number. Ejample3: "SomerandomeText21345678" PO=21345678 , The code must have into consideration that the PO could be at the end of the text string, so the 9th character could not be (null character is diferente than {"0","1","2","3","4","5","6","7","8","9"} I have been trying to solve this without any luck, it is time to ask for help, thank you guys in advance.