Wondering.... Why even click the dislike button? They can just leave the video if they didn’t like it right? Dear land lord, This video is amazing. Thank you for your presentation and knowledge.
Amazing as all your tutorials! So clear, no extra words or confusing extra mouse movements, everything to the point, clean and crispy. I think you are the best teacher in your field.
Already applied on my data. This video is really helpful. Got an appreciation from my Boss for the dashboards. Thank for your efforts in this video. Really appreciate it !
Mynda, I can't stop marveling about your presentation skills and the way you deliver these lessons to audience. Amazing job and appreciate all your effort !! Worth to highlight!!
I am from Taiwan and cannot find any satisfactory source in Chinese. It’s so glad to find your video which really help me to understand the key functions of power BI. Thank you very much!
Hi Mynda, I am a beginner and this is the most comprehensive Power BI tutorial I have seen. The way you teach really simple to follow, you make it look very easy. I would really appreciate if you can guide me to a tutorial regarding preparing / structuring / formatting your excel sheets / CSV files to import in PBI. Also I would love to see a tutorial apart from sales, budgeting or forecasts, like a online survey result where there are no dates involved (it would be a great help). Thank you very very much for this tutorial !!!
Great to hear you found this video helpful, Suhair! The data model in Power BI requires the data in a tabular format, but you can use the built in Power Query tool to get and clean the data from Excel worksheets, CSV files etc. and convert it into a tabular layout if it isn't already. I don't have any Power BI survey data examples, but these Excel examples might give you some ideas: www.myonlinetraininghub.com/segmented-survey-data-chart and this: www.myonlinetraininghub.com/excel-charts-for-surveys
@@MyOnlineTrainingHub I watched your video back 4yrs ago as my first Excel dashboard tutorial. I am now advanced in Excel and have moved over to Power BI last year. Though I know Power BI fairly well now, it' still nice to see your videos. You're a true inspiration :)
Really appreciate your instruction on building this report. I followed it step by step and learned a lot. Couple things would like to share. For the date columns in the source excel, they are formatted in UK dates for e.g. 1/2/2020 actually for 2/1/2020. So for USA learners like me, we need to format them to US dates otherwise the time related vis such as Line Chart won't work correctly. The other is about the running total measure, I created the formula with your code and checked it with data table. The numbers were not correct. I used the Quick Measure tool to generate the formular and checked it to make sure it worked. The one I have is: ISONORAFTER('Actuals'[Date], MIN('Actuals'[Date]), DESC) instead of MAX('Actuals'[Date], DESC). Thanks again for your wonderful teaching. Keep up the good work!
Glad you found it helpful! Yes, in the READ_ME_FIRST.txt file included with the data download for this video I explain the date issue and a link to a tutorial on changing type using Locale. Hopefully you found it and didn't waste time trying to figure out why the dates were wonky for you. MAX or MIN in the running total formula yields the same results, so there's no right or wrong.
@@MyOnlineTrainingHub Thank you for the explaination. I tried use the Locale to convert the date to US but didn't work. I then used "Split column" and "Merge column" to finally get it right. This was a good learning experience and helped me using different way to solve the problem. For the running total, you are correct, both MAX and MIN will work with the right sorting direction. I think for MAX, the sorting needs to be ASC. Thank you again for the wonderful lecture.
One of the best tutorials I've watched so far. Love presentation approach, zooming in, focusing on the elements and adding the extra notes to make it perfect. Well done! & THANK YOU! Subscribed :)
Hi, Great to see you sharing your knowledge on YT. I signed up to several of your Excel training programs a few years ago and they helped me enormously
Yes, Power BI is a vast app with what seems like endless functionality, which is why I put together a comprehensive course (www.myonlinetraininghub.com/power-bi-course). The idea of this video was to provide a lesson and data where you could try it out yourself and experience using it and a platform from where you can then go and learn more if you like it.
Great video, i am quite surprised how you managed to do a start to finish video with decent details in 41 minutes 😃 Following you for more videos like this 👍
Rather important amendment to your tutorial: In your budget file the untransformed loading of the budget column works only in English speaking countries, where your Thousands separator is a Comma and the decimal separator is a point. In other countries, as for example Germany, the separators are the other way. Thus you have to transform the budget column in the budget file as follows: - delete the Item "Changed Type" in the Query settings on the right edge. That unfortunately resets all the already automatically recognized and changed data types in all colums to Text, but unfortunately you can not change a once wrongly recognized column to another type. - now set the data type of all undoubted columns by "Detect Data Type" (Datentyp erkennen) - rightclick on the header of the suspicious column (wich is recognized as text due to the issues described below) --> context menu - Typ ändern (change data type) - Mit Gebietsschema (with locale settings) - change data type to decimal - *AND* change locale (Gebietsschema) to English (Australia) I am not sure about the corect menu denominations in the English version. Only now you have correct data. Otherwise you would have 30 data sets with values in the millions where the two thousands separators would be confused for two decimal separators, wich then cause an error in those 30 rows. Also check and transform all other files of unknown / foreign provenience that contain columns with date values or currency values.
Thanks for sharing, Uwe. In the files you downloaded from our site there is a file called READ_ME_FIRST.txt and in this file I explain how to change the data types for the dates using 'From Locale', as explained here: th-cam.com/video/QKgS3hrrmvw/w-d-xo.html This is the same issue you're having, except for thousand separators.
@@MyOnlineTrainingHub Yes: "except for thousand separators". But those are much more difficult do deal with. And they are usually much more. Of course I have read "READ ME" and watched that video, but sincerely: what are the odds to read a "READ ME" file? And as I mentioned in the comments there, the checkbox "column qualiy" doesn't work reliably, so if one is not so experienced with odd data and not so curious as me, he wouldn't even realize that he has a data problem - before a later step in the processing of that data. And if he wouldn't have figures over 1,000,000 he probably wouldn't realize it at all, because a 17,100 turned 17.1 will not even throw an error message. Therefor my recommendation for all people dealing with numerics of unknown origin (dates and numbers and percentages): check your data in Notepad++ (your file might be too long for Excel) and search with the following regular expressions for the existance of possibly problematic numbers: ".*,.?.?.?" - for numbers over one Thousand (containing one Thousands separator) ".*,.*,.?.?.?" - for numbers over one Million (containing at least two Thousands separators) The formulation of the regular expressions might be different in different local settings due to the same exasperating Comma-Point-Problem. For the understanding of regular expressions see here: www.regular-expressions.info/tutorial.html
Hi! I had the same problem, but there is another way to solve it. Firstly, I deleted the "Changed Type" as well, but then I split the column "Budget" by delimiter (comma) and finally merged the columns again. I am not sure if it is a final or correct solution, but for the example it helps.
@@MyOnlineTrainingHub Hi Mynda, I didn't figure out how to upload my file, So I will try rephrase my question, each month, there will be over 100 items purchase as products materials. and in order to analyses the trend, power BI is used for the analysis of each month's data ; there would be multiple sort options to be needed, first, data will be sorted by months, then we would like to sort out the items by value in the current period to focus on the top 20 or 50 ones; and review their trends from the highest value item to the lower value ones; hope this is better to understand. The question is POWER BI can only sort out items by all periods' accumulated total value, and cannot sort the items out per any single period's value. Thank you
Thank you very much. You probably dont even realize how much your lessons help me in my work and it probably saves me from losing my job. I do really appreciate your teaching us valuable lessons.
I'm confused. In the video it displays a gauge chart. If you're not seeing it in your own file, then I'd say the Q&A has changed and is no longer able to display it 🤷♀️
Thank you so much, I came upon this video because I needed to add a slicer, but I learned a lot more than I thought. Great video, will definitely be coming back to it.
I am regular learner from your videos. This is so far simplest and best video on Power BI. Look forward to see advance PBI videos covering essential DAX measure and advance data analysis.
@@MyOnlineTrainingHub Thanks.....so creative and simple......how can I inbox. I am put in back to back workload by my office. Which I am capable of doing. But being field sales manager things are quite divergent and convex. Need assistance to develop few dashboards if I could get support.
I don't do consulting, but if you want to learn how to build your own dashboards, please consider my course: www.myonlinetraininghub.com/excel-dashboard-course If you'd like me to refer you to a consultant, please get in touch via email: website at MyOnlineTrainingHub.com
Mynda you are the best subject matter expert on Power BI and Excel. Thank you so very much for educating us. I am a regular follower of all your videos and they are super helpful. Cheers!!!
@@MyOnlineTrainingHub This is excellent! Appreciate your dedication and of course your understanding of the subject matter. I would love to discuss partnership opportunities, do you mind sharing your email address please?
Thanks Mynda. You've done an excellent job at explaining how to build a very useful BvA report in Power BI. Great job, love your systematic step by step training. Now, to get busy building my own Power BI reports! Thanks so much!
Thanks for teaching in an organized and a disciplined way ... I need to shell out time to understand everything .... slowly but yes with your video I am confident that I'll do it .... Thanks again
All of a sudden, I feel woefully inadequate! LOL! Have some studying to do, I believe. Fantastic video on how to put all that together and on to the server. Thank you for the enlightenment! :)
Amazing and Professional. I love to check your Videos to give my Ideas the finish they need or check for complex solutions. Thank for your online content.
Thanks for this video. On the line chart @14:10, there is no longer a Values field but there is a Y-axis where I added Actual, Budget, and Forecast. However, PowerBI aggregates the data in this field to include only sums or averages, not the actual data points for each month. There is no option for "Don't summarize". How do I get the data on the y-axis to display for each month along the x-axis?
I suspect it's not the aggregation that's the problem, but rather the dates in your model need fixing for your region. See this video for how to do that: th-cam.com/video/QKgS3hrrmvw/w-d-xo.html
I studied Power BI for 5 months using a course I paid $40 a month for. This video is everything one needs to know about this application. I feel... flabbergasted.
Good day Mayda, have another question and try to find the solution; how can I sort out category's value per specific month while maintaining other periods'' value as well? It seems Power BI only can sort out by total if keep every single month's value. It would be much appreciated if you can provide some guidance.
Hi Mynda, what was the string of logic that you type in 15:13 about? CALCULATE(SUM(Actuals[Actual]), FILTER(ALLSELECTED('Calendar'[Date]), ISONORAFTER('Calendar'[Date],MAX(Actuals[Date]),DESC))) I understand that FILTER(ALLSELECTED('Calendar'[Date]) it is trying to limit the return of calculated result within the Calendar table which you have created earlier, which is the entire year only... And... at 16:32, you created a chart base from this string of input, that chart seems like a cumulative chart of the entire year. Was this necessary at all (because this chart seems redundant in terms of presentation) or you are trying to show case the computational string that Power BI has?
When you're working with costs you have an annual budget that is not necessarily spent in a linear fashion. The purpose of this chart is to show both the YTD spend to budget and the trend over time on a cumulative basis.
@@MyOnlineTrainingHub Can you please explain how ISONORAFTER, MAX, DESC support the running total calculation? MAX returns the largest value in a column, or between two scalar expressions - is this returning Jan 1, 2020?
Also while importing "Actual data" in colomn "Date" PowerBI sometimes places the whole sring, e.g. "1/01/2020,Administration,External Labor,United Kingdom,""1,754"". In the same time most of data importing well.
Thank you for explaining the reports in an eloquent manner. I downloaded the files and created the reports side by side watching your video. I had a bit of problem with the date ... turns out I have to set the date format to English (Australia), irrespective of what region you are in. I am in Canada
My pleasure, Gaurav. If you read the notes in the file called 'read me first' included in the zip file you downloaded you'll see an explanation for the date issue.
@@MyOnlineTrainingHub I did refer to the other video. U said change type to Ur local country date format one so I changed to English (canada) but it still captures till 12th Jan cause the format doesn't change. But don't worry about it, I figured out eventually that the it has to be for Australia country type only. Also, I watched the revenue analysis video. That was awesome too!
Hi Mynda, I was trying to learn how to create Dashboards for different data sets, when I came across your video. Learned lots from it! My only point would be that if you could explain why each visual is chosen on the dashboard, it would help us gain more insights.
This is a very good workdone.I love it, i decided to practice your tutorials step by steps but it appears using the inbuilt AI Q&A to display the Chart on Actual vs Budget as gauge returns a blank chart.Any help?
In this video I don't load all the data at the beginning. If you watch to the end, you'll see I add more data to demo how this is done. I suspect you have all the data loaded, which is why you're getting 145 million.
It seems when you add Forecast, it shows as an indicator but on mine it shows as a Value, therefore it shows as Sum of __ . this isnt the first data set I've worked with where it does this. Yes I can edit the title but do you perhaps know why yours shows different than mine? I'm at the 13:49 part, and it is titled as "Sum of Forecast and Sum by Date"
The 'Sum of' is a new 'feature' in Power BI. You can simply click on the drop down arrow for the field in the Visualizations pane and choose 'Rename for this visual' to remove 'sum of...'.
Thank you so much for your wonderful video! I have one question. I am trying to follow your steps but my PowerBI is recognizing all dates as January. I tried to change the local setting to UK and US to see if it makes any difference but still no luck. Do you have any tips for these problems? Thanks!
To fix the dates, you need to go to the first Changed Type step in Power Query and delete it. Then right-click the date columns (one by one) and choose 'Change Type' > 'Using Locale...' > select Date for the data type and 'English (Australia)' for the locale.
well this is an alien thing ... My native language is Spanish, but I struggle to understand this with the subtitles, I have learned Power BI and English with you. I will follow your channel.
Wondering.... Why even click the dislike button? They can just leave the video if they didn’t like it right? Dear land lord, This video is amazing. Thank you for your presentation and knowledge.
Thanks so much for your kind words and support, Jin!
Amazing as all your tutorials! So clear, no extra words or confusing extra mouse movements, everything to the point, clean and crispy. I think you are the best teacher in your field.
Wow, thanks for your kind words, Victoria!
Already applied on my data. This video is really helpful. Got an appreciation from my Boss for the dashboards. Thank for your efforts in this video. Really appreciate it !
Congratulations on your success with Power BI, Diana! Great to know I could help.
Congratulations!!!
I learned so much ... thank goodness its the weekend so I can relax and reflect on it
Great to hear!
Mynda, I can't stop marveling about your presentation skills and the way you deliver these lessons to audience. Amazing job and appreciate all your effort !! Worth to highlight!!
Thank you so much, Rodion! 😃
I am from Taiwan and cannot find any satisfactory source in Chinese. It’s so glad to find your video which really help me to understand the key functions of power BI. Thank you very much!
Glad it was helpful!
Hi Mynda, I am a beginner and this is the most comprehensive Power BI tutorial I have seen. The way you teach really simple to follow, you make it look very easy. I would really appreciate if you can guide me to a tutorial regarding preparing / structuring / formatting your excel sheets / CSV files to import in PBI. Also I would love to see a tutorial apart from sales, budgeting or forecasts, like a online survey result where there are no dates involved (it would be a great help).
Thank you very very much for this tutorial !!!
Great to hear you found this video helpful, Suhair! The data model in Power BI requires the data in a tabular format, but you can use the built in Power Query tool to get and clean the data from Excel worksheets, CSV files etc. and convert it into a tabular layout if it isn't already. I don't have any Power BI survey data examples, but these Excel examples might give you some ideas: www.myonlinetraininghub.com/segmented-survey-data-chart and this: www.myonlinetraininghub.com/excel-charts-for-surveys
This is the clearest and most simplest training instructor I've seen. Really love her content. Please keep it up! :D
Wow, thank you! 🥰
@@MyOnlineTrainingHub I watched your video back 4yrs ago as my first Excel dashboard tutorial. I am now advanced in Excel and have moved over to Power BI last year. Though I know Power BI fairly well now, it' still nice to see your videos. You're a true inspiration :)
Wow! Congratulations on your success!
Very clean, no repetition and many interesting hints included. Will look for more complicated topics explained in this channel. Good job! Thanks!
Glad you liked it 😊
Really appreciate your instruction on building this report. I followed it step by step and learned a lot. Couple things would like to share. For the date columns in the source excel, they are formatted in UK dates for e.g. 1/2/2020 actually for 2/1/2020. So for USA learners like me, we need to format them to US dates otherwise the time related vis such as Line Chart won't work correctly. The other is about the running total measure, I created the formula with your code and checked it with data table. The numbers were not correct. I used the Quick Measure tool to generate the formular and checked it to make sure it worked. The one I have is: ISONORAFTER('Actuals'[Date], MIN('Actuals'[Date]), DESC) instead of MAX('Actuals'[Date], DESC).
Thanks again for your wonderful teaching. Keep up the good work!
Glad you found it helpful! Yes, in the READ_ME_FIRST.txt file included with the data download for this video I explain the date issue and a link to a tutorial on changing type using Locale. Hopefully you found it and didn't waste time trying to figure out why the dates were wonky for you. MAX or MIN in the running total formula yields the same results, so there's no right or wrong.
@@MyOnlineTrainingHub Thank you for the explaination. I tried use the Locale to convert the date to US but didn't work. I then used "Split column" and "Merge column" to finally get it right. This was a good learning experience and helped me using different way to solve the problem. For the running total, you are correct, both MAX and MIN will work with the right sorting direction. I think for MAX, the sorting needs to be ASC. Thank you again for the wonderful lecture.
One of the best tutorials I've watched so far. Love presentation approach, zooming in, focusing on the elements and adding the extra notes to make it perfect. Well done! & THANK YOU! Subscribed :)
Awesome, thank you, Catalin!
I have bookmarked this Video for future learning. I am a beginner in PowerBI. Thank you for the lovely illustration
Glad it was helpful!
Hi Mynda. Looks like a great training. Looking forward to walking through it in depth with the data files. Thanks for sharing. Thumbs up!!
Thanks for your support, Wayne!
@@MyOnlineTrainingHub pls share the link to download
Hi, Great to see you sharing your knowledge on YT. I signed up to several of your Excel training programs a few years ago and they helped me enormously
So happy to read that! Thank you for your kind words of support 😊
One of the best starting videos for new PBI users. Thanx a lot, Mynda!
Glad you enjoyed it!
I don't usually like to comment, but when I do it's for an amazing tutorial like yours. Excellent presentation!
Wow! Thank you, Mesfin 😊
This is amazing. So simple to follow and execute, even with what I’d characterize as moderate (at best) Excel skills. Thank you!
Glad it was helpful!
I usually enjoy your videos but there were so many subjects that you seemed to not mention for someone just learning. Thank you for your other work.
Yes, Power BI is a vast app with what seems like endless functionality, which is why I put together a comprehensive course (www.myonlinetraininghub.com/power-bi-course). The idea of this video was to provide a lesson and data where you could try it out yourself and experience using it and a platform from where you can then go and learn more if you like it.
Excellent tutorial. Appreciate your approach to pacing and content leveling, thanks!
Great to hear :-)
@@MyOnlineTrainingHub share with me some files or books to use
most clear and clean tutorial. no non sense straight to the point and topic. i loved it
Thanks so much!
Great video, i am quite surprised how you managed to do a start to finish video with decent details in 41 minutes 😃 Following you for more videos like this 👍
Glad you enjoyed it, Saleh!
If you want to learn, watch this video. Thank you Mynda, you are superb at what you do.
Thanks for your support, Jamie! 😊
I'm Abdulai from Ghana
How do I access your documents to practice ma'am
Rather important amendment to your tutorial:
In your budget file the untransformed loading of the budget column works only in English speaking countries, where your Thousands separator is a Comma and the decimal separator is a point. In other countries, as for example Germany, the separators are the other way. Thus you have to transform the budget column in the budget file as follows:
- delete the Item "Changed Type" in the Query settings on the right edge. That unfortunately resets all the already automatically recognized and changed data types in all colums to Text, but unfortunately you can not change a once wrongly recognized column to another type.
- now set the data type of all undoubted columns by "Detect Data Type" (Datentyp erkennen)
- rightclick on the header of the suspicious column (wich is recognized as text due to the issues described below) --> context menu
- Typ ändern (change data type)
- Mit Gebietsschema (with locale settings)
- change data type to decimal
- *AND* change locale (Gebietsschema) to English (Australia)
I am not sure about the corect menu denominations in the English version.
Only now you have correct data. Otherwise you would have 30 data sets with values in the millions where the two thousands separators would be confused for two decimal separators, wich then cause an error in those 30 rows.
Also check and transform all other files of unknown / foreign provenience that contain columns with date values or currency values.
Thanks for sharing, Uwe. In the files you downloaded from our site there is a file called READ_ME_FIRST.txt and in this file I explain how to change the data types for the dates using 'From Locale', as explained here: th-cam.com/video/QKgS3hrrmvw/w-d-xo.html This is the same issue you're having, except for thousand separators.
@@MyOnlineTrainingHub Yes: "except for thousand separators". But those are much more difficult do deal with. And they are usually much more.
Of course I have read "READ ME" and watched that video, but sincerely: what are the odds to read a "READ ME" file?
And as I mentioned in the comments there, the checkbox "column qualiy" doesn't work reliably, so if one is not so experienced with odd data and not so curious as me, he wouldn't even realize that he has a data problem - before a later step in the processing of that data.
And if he wouldn't have figures over 1,000,000 he probably wouldn't realize it at all, because a 17,100 turned 17.1 will not even throw an error message.
Therefor my recommendation for all people dealing with numerics of unknown origin (dates and numbers and percentages): check your data in Notepad++ (your file might be too long for Excel) and search with the following regular expressions for the existance of possibly problematic numbers:
".*,.?.?.?" - for numbers over one Thousand (containing one Thousands separator)
".*,.*,.?.?.?" - for numbers over one Million (containing at least two Thousands separators)
The formulation of the regular expressions might be different in different local settings due to the same exasperating Comma-Point-Problem.
For the understanding of regular expressions see here: www.regular-expressions.info/tutorial.html
Hi! I had the same problem, but there is another way to solve it. Firstly, I deleted the "Changed Type" as well, but then I split the column "Budget" by delimiter (comma) and finally merged the columns again. I am not sure if it is a final or correct solution, but for the example it helps.
Thank you for getting back to me , Mynda. Let me figure out how to upload the file. You have a good day！
No worries. And you 😊
@@MyOnlineTrainingHub Hi Mynda, I didn't figure out how to upload my file, So I will try rephrase my question, each month, there will be over 100 items purchase as products materials. and in order to analyses the trend, power BI is used for the analysis of each month's data ; there would be multiple sort options to be needed, first, data will be sorted by months, then we would like to sort out the items by value in the current period to focus on the top 20 or 50 ones; and review their trends from the highest value item to the lower value ones; hope this is better to understand. The question is POWER BI can only sort out items by all periods' accumulated total value, and cannot sort the items out per any single period's value. Thank you
the best power bi presentation and expanation I have witnessed so far !
Wow, that's awesome to hear!
Thank you very much. You probably dont even realize how much your lessons help me in my work and it probably saves me from losing my job. I do really appreciate your teaching us valuable lessons.
Wow! I’m grateful I can help in some way, but really it’s you who’s doing the work and that tenacity is what helps keep you in a job.
@@MyOnlineTrainingHub Thank you, please keep educating us.
In 12:11. the Q/A, the result of "actual vs budget as gauge" is blank, why ? thanks
I'm confused. In the video it displays a gauge chart. If you're not seeing it in your own file, then I'd say the Q&A has changed and is no longer able to display it 🤷♀️
Mam, Your explanation is very clear and one of the best video on Power BI and excel in TH-cam thank you .
Wow, thanks so much, Vijay!
this is one of the best tutorials i have watched
Wow! Thanks so much 😊🙏
Your videos are the gold standard. TH-cam should direct everyone to you and save a lot of wasted time elsewhere!
Thanks so much 🙏
No question but only a thank you for your continued services!
I appreciate that!
Thank you so much, I came upon this video because I needed to add a slicer, but I learned a lot more than I thought. Great video, will definitely be coming back to it.
Great to hear, Maiara!!
I am regular learner from your videos. This is so far simplest and best video on Power BI. Look forward to see advance PBI videos covering essential DAX measure and advance data analysis.
Great to hear! DAX to come 😉
@@MyOnlineTrainingHub Thanks.....so creative and simple......how can I inbox. I am put in back to back workload by my office. Which I am capable of doing. But being field sales manager things are quite divergent and convex. Need assistance to develop few dashboards if I could get support.
I don't do consulting, but if you want to learn how to build your own dashboards, please consider my course: www.myonlinetraininghub.com/excel-dashboard-course If you'd like me to refer you to a consultant, please get in touch via email: website at MyOnlineTrainingHub.com
Mynda you are the best subject matter expert on Power BI and Excel. Thank you so very much for educating us. I am a regular follower of all your videos and they are super helpful. Cheers!!!
You are so welcome, Muhammad!
You taught me power query now you're up to this... TYSM. You're amazing.
Thanks so much 😊
What platform are you using to display the tutorial? Zooming @ 2:49 to the specific point was excellent
I used Camtasia Studio for that video.
@@MyOnlineTrainingHub This is excellent! Appreciate your dedication and of course your understanding of the subject matter. I would love to discuss partnership opportunities, do you mind sharing your email address please?
Wow ... nice tutorial and very smart lady ❤❤❤❤❤
Thanks so much 🙏
Waou, I am amazed by the clarity of your explanation. Thank you for the excellent job you put in here!!
Thanks so much!
Thanks Mynda. You've done an excellent job at explaining how to build a very useful BvA report in Power BI. Great job, love your systematic step by step training. Now, to get busy building my own Power BI reports! Thanks so much!
Great to hear, Bob! Have fun with Power BI :-)
Thanks for teaching in an organized and a disciplined way ... I need to shell out time to understand everything .... slowly but yes with your video I am confident that I'll do it .... Thanks again
Great to hear it was helpful, Venkat! Have fun with Power BI :-)
All of a sudden, I feel woefully inadequate! LOL! Have some studying to do, I believe. Fantastic video on how to put all that together and on to the server. Thank you for the enlightenment! :)
😁Glad it was helpful!
This is amzing..nice pace, short and concised. I learned a lot is so short time! Thank you!
You're most welcome!
Simply the best. Better than all the rest!
You will get me a raise 😂
Glad I could help 😉
I thank you so much for this explanation, it made it so easy to understand an assignment I had left until last minute
Glad I could help 😊
Hi Mynda, You are a Super Pro. Liked the coaching to the fullest. Will subscribe to view all your videos . Thanks a ton.
Awesome! Thank you!
Amazing and Professional. I love to check your Videos to give my Ideas the finish they need or check for complex solutions. Thank for your online content.
Great to hear, Marc!
found this to be a better overview and example of a "first" report than the one from a dedicated PowerBI channel.
thanks!
Wow, thanks, Zac!
Thank you for this free course!
Our pleasure!
Very concentrated and effective course
Glad you think so!
I love your training Mynda! Finally I have built my own dashboards by following your tutorial :) Thanks for sharing!
Congratulations, Victoria!
Hi Mynda, great tutorial. Thank you.
Thanks for watching!
I really appreciate your methodical and thoughtful steps that you showed in the video.
Glad it was helpful!
Thanks for this video. On the line chart @14:10, there is no longer a Values field but there is a Y-axis where I added Actual, Budget, and Forecast. However, PowerBI aggregates the data in this field to include only sums or averages, not the actual data points for each month. There is no option for "Don't summarize". How do I get the data on the y-axis to display for each month along the x-axis?
I suspect it's not the aggregation that's the problem, but rather the dates in your model need fixing for your region. See this video for how to do that: th-cam.com/video/QKgS3hrrmvw/w-d-xo.html
Thank you! Clear, concise and extremely knowledgable presentation
Glad you liked it 😊
Excellent. Found no one could teach in the you do. Earned a lot of knowledge of the requirements and power bi tool as well. Thanks a lot maam
Wow, that's awesome to hear! Thank you 😊
Love the way you present these..
Thanks so much!
Hi Mynda, @14:19 when doing line i am getting three dots instead of lines.
That will be a locale issue. See this video for the solution: th-cam.com/video/QKgS3hrrmvw/w-d-xo.html
Yes, I have tried that and data is same as shown in the video but still i am not able to get the line chart.@@MyOnlineTrainingHub
Your ability to transfer knowledge is amazing. Thank you for sharing 🙏
My pleasure, Kuben!
8:14, so for those imported tables: when they have common column names, POWER BI would recognize them and link tables together, right?
Yes, if auto-detect relationships is turned on in the Power BI settings.
How I wish you had more Power BI videos!!
Working on it :-)
Half-way in, great so far! Thank you
Awesome to hear 😁🙏
I studied Power BI for 5 months using a course I paid $40 a month for. This video is everything one needs to know about this application. I feel... flabbergasted.
So pleased this video was helpful to you!
You got a subscriber here. Excellent work !!
Awesome, thank you!
Good day Mayda, have another question and try to find the solution; how can I sort out category's value per specific month while maintaining other periods'' value as well? It seems Power BI only can sort out by total if keep every single month's value. It would be much appreciated if you can provide some guidance.
Not sure what you mean. Maybe best to post your question on the Power BI Community Forum where you can share screenshots and files.
Excellent video. You made Power BI very easy to understand. Thank you very much.
Glad to hear that!
Hi Mynda, what was the string of logic that you type in 15:13 about? CALCULATE(SUM(Actuals[Actual]), FILTER(ALLSELECTED('Calendar'[Date]), ISONORAFTER('Calendar'[Date],MAX(Actuals[Date]),DESC)))
I understand that FILTER(ALLSELECTED('Calendar'[Date]) it is trying to limit the return of calculated result within the Calendar table which you have created earlier, which is the entire year only...
And... at 16:32, you created a chart base from this string of input, that chart seems like a cumulative chart of the entire year.
Was this necessary at all (because this chart seems redundant in terms of presentation) or you are trying to show case the computational string that Power BI has?
When you're working with costs you have an annual budget that is not necessarily spent in a linear fashion. The purpose of this chart is to show both the YTD spend to budget and the trend over time on a cumulative basis.
@@MyOnlineTrainingHub Can you please explain how ISONORAFTER, MAX, DESC support the running total calculation? MAX returns the largest value in a column, or between two scalar expressions - is this returning Jan 1, 2020?
Mynda is super lady her explanation is amazing ...Keep making more dashboard please . I am biggest biggest fan
Thanks for your kind words, Gagan!
Thanks a lot Mynda for sharing your knowledge. It really helped me to understand PowerBI. The whole content and tutorial are amazing.
Great to hear 😊
Simply perfect! Thanks a lot Mynda!
Thanks so much 🙏😁
The IA is stunning!
The IA?
@@MyOnlineTrainingHub Inteligencia Artificial - IA, jajaja that happens to me sometimes
Oh, we call it AI in English :-)
Thanks for sharing! Could not find your Intro to Power BI video on YT. Do you mind letting me know the title of the recording? Cheers
This is my most recent an intro to Power BI video.
Can you explain the Measures you have written for the Actual RT , Budget RT , and Forcast RT
Please see this tutorial: th-cam.com/video/9VeAmodOvMc/w-d-xo.html
Thanks for your response
each charts were uniquely used awesome teaching....please bring more content videos using dax
Glad you liked it 😊
Madam you rocks . GOD BLESS YOU 👌😊
Thanks so much 😊
Excellent tutorial Mynda - many thanks
Glad you liked it 😊
very informative tutorial, clear and simple, thank you
Glad it was helpful!
You have helped me in understanding power bi . Thank you so much
My pleasure 😊
Also while importing "Actual data" in colomn "Date" PowerBI sometimes places the whole sring, e.g. "1/01/2020,Administration,External Labor,United Kingdom,""1,754"". In the same time most of data importing well.
That's odd. You should be able to specify the delimiter on import.
very clear explaination and good teaching method !
Thanks so much, Mua!
Really help me so much. Thank you so much. Looking for advance Powerbi from you soon. A Million thank you to you
Happy to hear that!
This is so good
I’m following right now.
Watched through and now I’m following with the dataset. Amazing
Thank you
Awesome to hear!
Very helpful. Can't wait to create my first Power BI visuals.
Great to hear 😊
Thank you for explaining the reports in an eloquent manner. I downloaded the files and created the reports side by side watching your video. I had a bit of problem with the date ... turns out I have to set the date format to English (Australia), irrespective of what region you are in. I am in Canada
My pleasure, Gaurav. If you read the notes in the file called 'read me first' included in the zip file you downloaded you'll see an explanation for the date issue.
@@MyOnlineTrainingHub I did refer to the other video. U said change type to Ur local country date format one so I changed to English (canada) but it still captures till 12th Jan cause the format doesn't change. But don't worry about it, I figured out eventually that the it has to be for Australia country type only. Also, I watched the revenue analysis video. That was awesome too!
There must be a mismatch with your locale settings in PQ. Glad you got it working though.
Very Informative video. It helped with my university assignment. :)
Great to hear 😊
Hi Mynda,
I was trying to learn how to create Dashboards for different data sets, when I came across your video. Learned lots from it!
My only point would be that if you could explain why each visual is chosen on the dashboard, it would help us gain more insights.
Glad you found it helpful!
This is a very good workdone.I love it, i decided to practice your tutorials step by steps but it appears using the inbuilt AI Q&A to display the Chart on Actual vs Budget as gauge returns a blank chart.Any help?
Thanks so much! I'd say it doesn't know which fields to put in the value and target fields.
This video helped my learning so much. Thank you.
Awesome to hear 😊
always awesome Mynda! thank you.
Glad you enjoyed it!
Very nice videos, I am trying to learn how to use Power BI, and your videos have been very helpful. Thanks!!!
Great to hear!
wow... awesome
Thanks 🥰🥰🥰🥰🥰🥰
Thank you 😊
Thanks. I have added your Lambda video to my June Newsletter. Hope you get tons of subscriptions. Best wishes from South Africa.
Thanks so much, Chris! Hope your readers enjoy my video.
Very educative video for beginners like me. ❤❤
Glad it was helpful!
Aloha - This works great !!! Thank you
Great to hear!
Thank you So much for the wonderful Presentation!
So nice of you, Suneetha!
Keep going... Great training.
Thank you, I will :-)
in 12:04 the AI version as gauge chart is not working. Moreover the value is not coming as 123 million mine is coming 145 million. kindly reply
In this video I don't load all the data at the beginning. If you watch to the end, you'll see I add more data to demo how this is done. I suspect you have all the data loaded, which is why you're getting 145 million.
It seems when you add Forecast, it shows as an indicator but on mine it shows as a Value, therefore it shows as Sum of __ . this isnt the first data set I've worked with where it does this. Yes I can edit the title but do you perhaps know why yours shows different than mine? I'm at the 13:49 part, and it is titled as "Sum of Forecast and Sum by Date"
The 'Sum of' is a new 'feature' in Power BI. You can simply click on the drop down arrow for the field in the Visualizations pane and choose 'Rename for this visual' to remove 'sum of...'.
Thank you so much for your wonderful video! I have one question. I am trying to follow your steps but my PowerBI is recognizing all dates as January. I tried to change the local setting to UK and US to see if it makes any difference but still no luck. Do you have any tips for these problems? Thanks!
To fix the dates, you need to go to the first Changed Type step in Power Query and delete it. Then right-click the date columns (one by one) and choose 'Change Type' > 'Using Locale...' > select Date for the data type and 'English (Australia)' for the locale.
well this is an alien thing ...
My native language is Spanish, but I struggle to understand this with the subtitles, I have learned Power BI and English with you. I will follow your channel.
Thanks for following :-)
The decomposition tree is new to me..very helpful.
Could you do an analysis for a snagging company or construction data sets❤❤
Glad it was worth your while. I don't have any construction datasets, unfortunately.