How to Build Power BI Reports from Start to Finish

[@bluesage1528]

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.

[@MyOnlineTrainingHub]

Wow, thanks for your kind words, Victoria!

[@Diana_Coutinho007]

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 !

[@MyOnlineTrainingHub]

Congratulations on your success with Power BI, Diana! Great to know I could help.

[@hanselcreado3570]

Congratulations!!!

[@rodionpopescu102]

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!!

[@MyOnlineTrainingHub]

Thank you so much, Rodion! 😃

[@SohairChauhan]

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 !!!

[@MyOnlineTrainingHub]

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

[@zonanagon9764]

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.

[@MyOnlineTrainingHub]

Thanks so much for your kind words and support, Jin!

[@webwatcher188]

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!

[@MyOnlineTrainingHub]

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.

[@webwatcher188]

@@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.

[@TA-DV]

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 :)

[@MyOnlineTrainingHub]

Awesome, thank you, Catalin!

[@franetw]

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!

[@MyOnlineTrainingHub]

Glad it was helpful!

[@lienecirule4342]

Very clean, no repetition and many interesting hints included. Will look for more complicated topics explained in this channel. Good job! Thanks!

[@MyOnlineTrainingHub]

Glad you liked it 😊

[@soomihong5058]

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!

[@MyOnlineTrainingHub]

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.

[@wayneedmondson1065]

Hi Mynda. Looks like a great training. Looking forward to walking through it in depth with the data files. Thanks for sharing. Thumbs up!!

[@MyOnlineTrainingHub]

Thanks for your support, Wayne!

[@lithinsyrus]

@@MyOnlineTrainingHub pls share the link to download

[@Nolan_the_Sir]

Hie Mynda, I was tasked to learn Power bi and your video was my first stop. I am very happy with your training, its exceptional. I got stuck the on line charts graphs around (17mins). I can not seem to get the line chart to appear in months, it only appears in days and years. Could you assist me? Thanks

[@MyOnlineTrainingHub]

Great to hear. Not sure what's up with the line chart, but I suspect the date hierarchy ins't correct in the axis field. Perhaps try building it again.

[@Nolan_the_Sir]

@@MyOnlineTrainingHub I started everything from scratch and I am still having the same problem. Did you update your data? I noticed when placing the commas in your actual column (11.12mins), your starts from March whereas mine from January. My gauge reading of the actual vs budget is 145m ranging from 0 to 289 which is far different from yours. By the way I re downloaded the files, so now I more confused, could you please help me figure out the error? thanks

[@sheriffakinyemi9762]

@@Nolan_the_Sir were you able to resolved this issue? I have the same problem, kindly help if you have. Thanks

[@jegareis]

This is amazing. So simple to follow and execute, even with what I’d characterize as moderate (at best) Excel skills. Thank you!

[@MyOnlineTrainingHub]

Glad it was helpful!

[@gauravgupta5539]

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

[@MyOnlineTrainingHub]

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.

[@gauravgupta5539]

@@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!

[@MyOnlineTrainingHub]

There must be a mismatch with your locale settings in PQ. Glad you got it working though.

[@Globa_me]

One of the best starting videos for new PBI users. Thanx a lot, Mynda!

[@MyOnlineTrainingHub]

Glad you enjoyed it!

[@shrikantbadge3978]

Mynda Madam this is my plan. First Practice Power Query properly. then Power Bi then DAX then SQL. is it the correct sequence ?

[@MyOnlineTrainingHub]

Perfect! Have fun with it. If you'd like to get your skills up to speed quickly, please consider my courses: www.myonlinetraininghub.com/power-bi-course

[@shrikantbadge3978]

ok@@MyOnlineTrainingHub

[@-nepherim]

Excellent tutorial. Appreciate your approach to pacing and content leveling, thanks!

[@MyOnlineTrainingHub]

Great to hear :-)

[@muhangiandrew8172]

@@MyOnlineTrainingHub share with me some files or books to use

[@makalontsasa4106]

Hi there Mynda, I enjoyed the video and was trying it right now. But I am stuck where the files had to be combined. Is there any easier way as I cannot seem to find it. otherwise the presentation is so clear and easy to follow

[@MyOnlineTrainingHub]

I’d say you have a different version of Power BI to me and maybe the button has a slightly different name. Hard to say without screenshots.

[@salehhazrami1566]

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 👍

[@MyOnlineTrainingHub]

Glad you enjoyed it, Saleh!

[@123ranjanrashmi]

I have bookmarked this Video for future learning. I am a beginner in PowerBI. Thank you for the lovely illustration

[@MyOnlineTrainingHub]

Glad it was helpful!

[@uwehaleksy]

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.

[@MyOnlineTrainingHub]

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: kzbin.info/www/bejne/h3zKhGaep9egrNk This is the same issue you're having, except for thousand separators.

[@uwehaleksy]

@@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

[@juanfranciscogiustina5895]

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.

[@haragopal123]

Hi Mynda, hope you are going well. This video has motivated me to bring out my question :) - I am trying to put together budget forecast vs actuals vs approved visuals for my IT project. Constraints are : my team of 6 work some % to another project (shared resources), calendar working days in each moth differ, their leaves to incorporated, some resources work 8hrs per day and some 7.5hrs. budget is catogorised as capex, opex and some vendor costs. with all this info. how many Excel tables I need and which visuals i need to incorporate it ? please advise . I have downloaded the available resources from the link provided and its a bit different to what my constraints are.. can you please assist ? many thanks in advance

[@MyOnlineTrainingHub]

Great to hear you're motivated to create your own Power BI reports. Your questions are a bit complex to answer in a forum like this, however, I presume you're already capturing this data and reporting on it, so you should be able to convert it to a Power BI report. It's probably best that you take a Power BI course. This should give you the fundamental skills so you can gather and clean the data, model it and visualise it. If you'd like to get up and running quickly, please consider my Power BI course: www.myonlinetraininghub.com/power-bi-course If you have questions, please reach out via email because I'm unlikely to see follow-up responses to this thread: website @ MyOnlineTraininghub.com

[@Durbandan]

I learned so much ... thank goodness its the weekend so I can relax and reflect on it

[@MyOnlineTrainingHub]

Great to hear!

[@22niloc]

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

[@MyOnlineTrainingHub]

So happy to read that! Thank you for your kind words of support 😊

[@nathand.567]

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.

[@MyOnlineTrainingHub]

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.

[@sadatirfan4629]

Hi Mynda,This tutorial is really helpful, but because I am from Indonesia, the use of commas for thousand separators is a bit different since here we use "." instead of ",". So, there are some challenges when getting data, and I have to manually change it first in the CSV file. Overall, thank you for the tutorial!

[@MyOnlineTrainingHub]

In that case, you can use Change Type > Using Locale as explained here in the context of dates: kzbin.info/www/bejne/h3zKhGaep9egrNk

[@mzzzzz2179]

This is the clearest and most simplest training instructor I've seen. Really love her content. Please keep it up! :D

[@MyOnlineTrainingHub]

Wow, thank you! 🥰

[@mzzzzz2179]

@@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 :)

[@MyOnlineTrainingHub]

Wow! Congratulations on your success!

[@zxu-zv2yy]

Thank you for getting back to me , Mynda. Let me figure out how to upload the file. You have a good day！

[@MyOnlineTrainingHub]

No worries. And you 😊

[@zxu-zv2yy]

​@@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

[@GabbyHeptaGON]

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?

[@MyOnlineTrainingHub]

Thanks so much! I'd say it doesn't know which fields to put in the value and target fields.

[@stevensarens7700]

Hey missus, does it make sense to use line charts for flow data? I always reckoned they're only suitable for stock data.

[@MyOnlineTrainingHub]

Struggling to picture what you would have on the x and y axis of the chart to answer that question. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

[@bartomiejsowik2178]

Is there possible to find and download data included in the video? Great tutorial!

[@MyOnlineTrainingHub]

Yes, you'll find the link in the video description.

[@omerbashasha4292]

There are a negative values in the expenses in all tables ?is that correct or should i convert them to positive values?

[@MyOnlineTrainingHub]

Yes, it's correct. From memory they are returns/refunds.

[@aliyasultana4171]

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.

[@MyOnlineTrainingHub]

Glad you found it helpful!

[@FS-ji3gk]

What platform are you using to display the tutorial? Zooming @ 2:49 to the specific point was excellent

[@MyOnlineTrainingHub]

I used Camtasia Studio for that video.

[@FS-ji3gk]

@@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?

[@zxu-zv2yy]

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.

[@MyOnlineTrainingHub]

Not sure what you mean. Maybe best to post your question on the Power BI Community Forum where you can share screenshots and files.

[@raymondchuah]

Excellent video. Do you need to add a calendar table for time / date slicer? Am i able to use the inbuilt date to calculate full year forecast where i select March for example and it will pick up Jan to Mar actuals and add up all remaining forecast values. Thanks

[@MyOnlineTrainingHub]

Yes, you can use the inbuilt date hierarchy for Slicers. In the earlier days of Power BI there were some limitations to working with the date hierarchy fields in measures etc. so as habit, I create my own date hierarchy.

[@raymondchuah]

@MyOnlineTrainingHub I was wondering if you could show me how it would be written? Thanks

[@bobthorp9111]

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!

[@MyOnlineTrainingHub]

Great to hear, Bob! Have fun with Power BI :-)

[@tanujapawar9929]

Can you explain the Measures you have written for the Actual RT , Budget RT , and Forcast RT

[@MyOnlineTrainingHub]

Please see this tutorial: kzbin.info/www/bejne/b4fIcqClmbSpg8U

[@tanujapawar9929]

Thanks for your response

[@ngwafabrice9561]

The decomposition tree is new to me..very helpful. Could you do an analysis for a snagging company or construction data sets❤❤

[@MyOnlineTrainingHub]

Glad it was worth your while. I don't have any construction datasets, unfortunately.

[@RakeshSingh-sq5go]

Hi! Just got started with your tutorial after having completed some other projects... I followed everything step by step but for some reason, the QnA AI visual doesn't work in my case. It can create a table for Actuals vs Budget but It just won't create a gauge, the visual just stays blank. And when I created one manually, the data comes out to be different than yours... Instead of 123M, my actuals are 145M and the budget in my visual is 289M as opposed to 246M in yours. What is it that's going wrong with my report ?

[@MyOnlineTrainingHub]

Remember, at the end of the video, I add more data to my model, so you will be working with the entire dataset and I am only working with part of it until the end. I don't think Q&A will create a gauge. Not all visuals are supported by Q&A.

[@jamieneville4945]

If you want to learn, watch this video. Thank you Mynda, you are superb at what you do.

[@MyOnlineTrainingHub]

Thanks for your support, Jamie! 😊

[@amoatanabseiduabdulai865]

I'm Abdulai from Ghana How do I access your documents to practice ma'am

[@sousousousouify]

Hello Amazing this is really helpful. However, I can’t find the gauge table in Q&A bor in the visuals, how to find it ?

[@MyOnlineTrainingHub]

Great to hear you found it helpful. The gauge chart requires a target, so I guess it’s not available from Q&A. Insert it from the visuals gallery instead.

[@paolamallkas]

Hello! This tutorial is amazing. I have a question: Where can I find the SolarM.json because I cannot find it in the downloaded data?

[@MyOnlineTrainingHub]

Glad you liked it! I didn't provide the solarM.json file, but it's a modification of the Solar theme, which is one of the built in themes, so you can use that as a starting point.

[@zxu-zv2yy]

It's amazing, Mynda. I have learned a lot from you other than this like excel keyboard shortcuts, but i still have a question about power BI on how to add the new period's data to existing Power BI file without starting this process from 0 again like adding next month's data (one by one when the period is coming.)? Your response is much appreciated!

[@MyOnlineTrainingHub]

Glad to hear you've found my tutorials helpful. In this video I show you how to add the new period's data, but the process may be different depending on where your source data is coming from. I cover in more detail in my Power BI course: www.myonlinetraininghub.com/power-bi-course

[@zxu-zv2yy]

@@MyOnlineTrainingHub Thank you so much for your response and the link , Mynda. I will watch it . Best regards!

[@zxu-zv2yy]

@@MyOnlineTrainingHub Thank you so much for sharing, i have watched the first one, I am assuming if the file location is changed, there would be error message in POWER BI report. I will watch this new one you recommended, Really appreciated, Mynda.

[@AW-ec4mk]

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

[@MyOnlineTrainingHub]

This is my most recent an intro to Power BI video.

[@mouns3326]

Thank you for this wonderful video, it helped me a lot, can you put the database in the description to practice the manipulation using the exact data, because i can't find any data online

[@MyOnlineTrainingHub]

The link to the data is in the video description. Follow the link and then read the instructions on the download page.

[@ramykandil9874]

Thanks Mynda for this amazing video I followed all steps but the numbers aren't the same.

[@MyOnlineTrainingHub]

Great to hear you liked this tutorial. Please read the 'READ ME FIRST' file you downloaded in the zip file with all the data files. This will explain why your numbers aren't the same and how to fix it.

[@Rehan-os5ui]

Hello, Is there any Rest API to pull column names from a Report ?

[@MinhTran-fw3xt]

Hi, thank you for your video! It is very helpful. However, when I downloaded the datasets, most data is repeated and dates only range from Jan 1 to Jan 15. How can I fix this?

[@MyOnlineTrainingHub]

Great to hear. Sounds like you didn't read the file called 'READ_ME_FIRST.txt' that you downloaded along with the other files. In there you'll find an explanation as to why you only see January dates, which requires a locale fix: kzbin.info/www/bejne/h3zKhGaep9egrNk

[@anupamadash6103]

Love the way you present these..

[@MyOnlineTrainingHub]

Thanks so much!

[@TatianaSmith831]

Great video. I wish you would have went a little slower and described where to find each tab. I’m having issues sharing to my team. The options to create an app seems to be the best solution for my need. Tried the other ways and it’s requesting my colleagues to buy a subscription. Can you tell me to get there. Your video doesn’t mention. Is this on the desktop app, the web version or via teams? I’m having trouble finding it.

[@MyOnlineTrainingHub]

Thanks for watching! Power BI gets updates regularly, so the menus in this video will be slightly different to what you see today. Anyone you want to share your reports with via the app will require a subscription. No way around it unless you embed your report in a webpage, but then it's publicly available. If you want to get up to speed with Power BI, I updated my course a couple of months ago, so it'll show you the current menus: www.myonlinetraininghub.com/power-bi-course

[@hfz9177]

hi Mynda, great training, thanks a lot, i have one question, in the line graph im seeing only data for Jan, im not able to see all months

[@MyOnlineTrainingHub]

Hi Hafiz, it sounds like your date format is mm/dd/yyyy and mine is dd/mm/yyyy. You need to remove the change type steps and re-apply them using change type > using locale. Choose data type, Date and locale as English (Australia).

[@misskkp]

this is one of the best tutorials i have watched

[@MyOnlineTrainingHub]

Wow! Thanks so much 😊🙏

[@jwilder2251]

Your videos are the gold standard. KZbin should direct everyone to you and save a lot of wasted time elsewhere!

[@MyOnlineTrainingHub]

Thanks so much 🙏

[@hivijay16]

Mam, Your explanation is very clear and one of the best video on Power BI and excel in KZbin thank you .

[@MyOnlineTrainingHub]

Wow, thanks so much, Vijay!

[@thulasidasskalidas7115]

Thank you Mynda. Do you conduct onlline training for BI courses?

[@MyOnlineTrainingHub]

Yes, indeed. You can find it here: www.myonlinetraininghub.com/power-bi-course

[@IMAS7512]

Hi dear, can u define some most important visual, that how to use correctly or where should we put actual, budget, %ach in which axis or legend in kpi card, line, column, area, card(new), etc. I have learned so much from your videos i need some more basic skills to make my actual vs sales presentation.

[@MyOnlineTrainingHub]

I'll think about putting a data visualisation course together. In the meantime, I recommend any of Stephen Few's books.

[@rakeshvishwanath3758]

Hi, how to create calendar visual and also highlight the picked dates?

[@MidtownMadness1]

Half-way in, great so far! Thank you

[@MyOnlineTrainingHub]

Awesome to hear 😁🙏

[@nakalyangomolly7828]

Thanks for the presentation , am trying to download the files but i cant reach the page

[@MyOnlineTrainingHub]

The page is working fine. Perhaps try a different browser. If you're still having trouble, please reach out via email available on our Contact Us page.'

[@katendefrancis6349]

No question but only a thank you for your continued services!

[@MyOnlineTrainingHub]

I appreciate that!

[@franksomto3211]

Hi Mynda, Thanks for this wonderful tutorial. Just a slight issue, My line chart doesn't displays dots instead of the lines as seen in the tutorial. How can I change this?

[@MyOnlineTrainingHub]

Hi Frank, please read the file called Read_me_first in the folder you downloaded with the source data etc. you’ll find the solution in there.

[@SGH-rt6ci]

Hi, is it possible to use excel pivot table as a data source for powerbi and every time I change something in my excel pivot table, this will be reflected in my powerbi ? My excel pivot table is connected to our GL therefore I have always the updated data. Thank you for your time.

[@MyOnlineTrainingHub]

Kind of. You wouldn't use the PivotTable, you'd use the same source data as your PivotTable i.e. connect Power BI to your GL.

[@Ryiah87]

Thank you for this free course!

[@MyOnlineTrainingHub]

Our pleasure!

[@fatihkilinc7818]

the best power bi presentation and expanation I have witnessed so far !

[@MyOnlineTrainingHub]

Wow, that's awesome to hear!

[@vijju1567]

most clear and clean tutorial. no non sense straight to the point and topic. i loved it

[@MyOnlineTrainingHub]

Thanks so much!

[@banksofnoon7867]

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.

[@MyOnlineTrainingHub]

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.

[@banksofnoon7867]

@@MyOnlineTrainingHub Thank you, please keep educating us.

[@Termoils61]

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]

You are so welcome, Muhammad!

[@nikolagorgievski6846]

I need the card with the measures to be interactive so i can click on the one i need to show the result for , any tip?

[@MyOnlineTrainingHub]

You’ll have to use a slicer for that.

[@perrytheplatypus95]

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?

[@MyOnlineTrainingHub]

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: kzbin.info/www/bejne/h3zKhGaep9egrNk

[@AnaVonKilgannon]

You taught me power query now you're up to this... TYSM. You're amazing.

[@MyOnlineTrainingHub]

Thanks so much 😊

[@atimstella1899]

I cant seem to find the link with the raw data sources, I would like to follow through with the same exact data you are using for the demo

[@MyOnlineTrainingHub]

The link is in the video description, then on the page you're taken to are further instructions. Reach out via our website if you're still stuck.

[@احمدالشهري-ر4ي]

Hi, tremendous work you have done here I have a problem with the line chart It doesn't show the lines unless I mark the date as date table but when I do that the hierarchy disappears

[@MyOnlineTrainingHub]

I wonder if you have a locale issue with the dates when they were imported. If your region uses mm/dd/yyyy date format then you need to use this technique when getting the data with Power Query: kzbin.info/www/bejne/h3zKhGaep9egrNk

[@zhin13]

Thank you for the great tutorial! Followed it start to finish. I only struggled when you used the AI which I don't have on my version. Also got stuck on the map when it wouldn't show colour... Realised that I selected "County" instead of "Country" 😖

[@MyOnlineTrainingHub]

Great to hear you built it yourself 👍

[@pawanmishra7487]

Good explanation but I need to know what exactly future of ms excel will be used in future or not if we compare with other tools like power bi, tablu and so on.... Enable us to save time....? What's basic different between power bi and tablu?

[@MyOnlineTrainingHub]

There will always be a future for Excel as it isn't solely a reporting tool. However, you might find this comparison video helpful: kzbin.info/www/bejne/Zp-kgmqdhbSSbLs I don't use Tableau.

[@zinebor6336]

Hello Mynda, thanks a lot for your sharings, I learned a lot from your excel's tutorials, and now I started learning Power BI, I have a question please, can I publish the work without an account, or it's a necessity, thanks again

[@MyOnlineTrainingHub]

Glad you're finding my tutorials useful, Zineb :-) you can publish your reports to the Power BI service with a free account, but you need a Pro account to share your reports with others, and those you're sharing the reports with also need a Pro account.

[@rephechaun]

This is amzing..nice pace, short and concised. I learned a lot is so short time! Thank you!

[@MyOnlineTrainingHub]

You're most welcome!

[@mesfinlenth3203]

I don't usually like to comment, but when I do it's for an amazing tutorial like yours. Excellent presentation!

[@MyOnlineTrainingHub]

Wow! Thank you, Mesfin 😊

[@Everyonelovesyou]

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]

Great to hear! DAX to come 😉

[@Everyonelovesyou]

@@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.

[@MyOnlineTrainingHub]

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

[@dieuvinh6657]

Hi Mynda. I have assigned to learn Power BI and apply it for our internal dashboard. Your videos are great help to me. Thank you so much. Still I get stuck with my data over years and a variety of KPIs to show. In such a case, I fail to show, let say each KPI 2020 Actual, 2021 Budget, 2021 Actual in a same chart, month wise, in which 2021 Actual is a line, the others are columns. I think my problem is firstly data organization but haven't found a solution yet. Can you please help me? Thanks a lot. I can explain better if I have an opportunity to email you a sample.

[@MyOnlineTrainingHub]

Great to hear, Dieu. Please post your question and sample Power BI file on our Power Pivot forum where we can help you further: www.myonlinetraininghub.com/excel-forum

[@dieuvinh6657]

@@MyOnlineTrainingHub Thanks. I have signed up in the forum but couldn't find the function to post a question.

[@ZhiyangLin]

Hi, in your video 14'11'', I am wondering why my visualization for the line chart appears to be three dots for Actual, Budget, and Forecast instead of the lines shown in your video? Thanks

[@MyOnlineTrainingHub]

It'll be because you need to change the date data type using locale as explained here: kzbin.info/www/bejne/h3zKhGaep9egrNk

[@divinejude2953]

Amazing Visual!! What page size did you use?

[@MyOnlineTrainingHub]

Thank you! I set my page to 16:9.

[@kgopolangtshabalala6766]

Can I build all of these visuals on Excel?

[@MyOnlineTrainingHub]

Yes, but you won't have the cross filter and highlight functionality or the secure sharing that Power BI offers. If you'd like to see how you can build dashboards in Excel, checkout my playlist here: kzbin.info/aero/PLmd91OWgLVSLy87GfZCR74BG1nhO7ER0s

[@Khan-mc3gi]

Great work u save lot of time i saw lot of report they take more then one hour to make and learn nothing to much 😂 your work is outstanding there i want to ask your that how much time require to make expert in power b.i from zero to expert.your reply will be valuable for us.

[@MyOnlineTrainingHub]

So pleased my video was helpful 😊 how long to become a Power BI expert is different for each person because it depends on your existing experience, how quickly you learn, and most importantly, how much work you put into practicing. It could take anything from a few months of intensive training to years. I’d err on the side of years for most people 😉

[@joshhenry1545]

On the data source, do you know if QB Desktop P&L reports exported to Excel can be imported into PowerBi easily? I have made a few attempts but I'm realizing that the layout of the report as it stands doesn't fit into PowerBi as is and may need some updates. Do you have any videos on formating the data from the accounting software into a file that will be useful for PowerBi?

[@MyOnlineTrainingHub]

Yes, it's possible to convert QBs reports with Power Query. It'll require several steps to remove the subtotals and unpivot the columns etc. I cover all the transformation techniques in my Power Query course: www.myonlinetraininghub.com/excel-power-query-course

[@jubaeralamsonet851]

hi thanks for sharing. one question, is there any way to transfer or copy the PQ steps to power BI so that the steps do not have to repeat again again.?

[@MyOnlineTrainingHub]

My pleasure! You can right click the query name in the query pane in Excel > copy. Then in Power BI create a new blank query and open the advanced editor and paste it in.

[@yitongsun6702]

Very concentrated and effective course

[@MyOnlineTrainingHub]

Glad you think so!

[@MKENAWI]

Excellent one.... can we have the data used in excel format?

[@MyOnlineTrainingHub]

See the link in the video description.

[@zxu-zv2yy]

Hi Mynda, hope all is well! I have followed your instructions, ensure the file name and worksheet name are same. And simply refresh the Power BI with adding new period data, I noticed that total amount actually incudes the new period data, just the new period name didn't show up. Like, previously I have January and February in Power BI, when I added new period for March, the period March doesn't show up, instead of "Blank" show up. And when I went back to query and I found the list is "January, February and Null" . How should I fix it? Thank you

[@MyOnlineTrainingHub]

Hard to say what's causing this as I'm not sure if you're using my data or your own data. You could always Replace null with March.

[@zxu-zv2yy]

@@MyOnlineTrainingHub Thank you so much for your response, Mynda. I will try your it per your suggestion . You have a good one !

[@oddyoddster]

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.

[@MyOnlineTrainingHub]

So pleased this video was helpful to you!

[@stanwouters4181]

Perfect view on PowerBI Desktop and Services. The case study, video, speed, voice, ...everything is ideally suited to study. Thanks Mynda. There are only problems with bringing in currency columns from the actuals (csv) . PowerBI does not import the values above $ 999,999.00 and shows 11 errors for the first 6 months. What could be the problem?

[@MyOnlineTrainingHub]

Thanks for your kind words, Stan! Not sure what's causing the problem with values >= 1m. Please post your question and sample CSV file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum

[@stanwouters4181]

@@MyOnlineTrainingHub I Found the problem. Before changing the format I have to replace the , to . and after that one can change the text to numbers, otherwise there are numbers with two decimal signs, which causes that error.

[@vanessaaguilar9026]

Hi I'm a complete newbie what is the relationship tool for?

[@MyOnlineTrainingHub]

To connect the tables in the model so you can build visuals using fields from multiple tables.

[@jupiter792]

Is it possible, within PowerBI to have several different categories within one report?

[@MyOnlineTrainingHub]

Yes.

[@jupiter792]

@@MyOnlineTrainingHub Thank you :)

[@jupiter792]

Have you done a video showing how to create several different categories within one report? If you have, could you share the link please?

[@ivychan598]

Thank you Mynda for this great video. Question, how can I make my US Power BI desktop to work with the UK date format? I changed the locale in Options > Current File > Regional Settings, but I still couldn't create the line chart with date. Thanks.

[@MyOnlineTrainingHub]

Hi Ivy, you can leave your system settings as is. Just remove the first Changed Type step that's automatically applied. Then select the date column > right-click change type > Using Locale... In the dialog box choose 'Date' and Locale 'English (Australia)'. Mynda

[@maiaracarvalho6573]

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.

[@MyOnlineTrainingHub]

Great to hear, Maiara!!

[@sen2576]

I wonder if the same dashboards can be done with Tableau, using the same data sets

[@jhormangomez2268]

The IA is stunning!

[@MyOnlineTrainingHub]

The IA?

[@jhormangomez2268]

@@MyOnlineTrainingHub Inteligencia Artificial - IA, jajaja that happens to me sometimes

[@MyOnlineTrainingHub]

Oh, we call it AI in English :-)

[@leenajames6888]

can we get the datasource to try this out?

[@MyOnlineTrainingHub]

The link is in the video description.

[@mishalsharekh2983]

very informative tutorial, clear and simple, thank you

[@MyOnlineTrainingHub]

Glad it was helpful!

[@temitopefolarin8289]

Good day thank you for this information but I tried the Q and A thing for the first visualization it didn’t work but it’s working for bar plot

[@MyOnlineTrainingHub]

Glad you found it helpful. Not sure why Q&A didn't work for the first visualisation, but at least you were able to use it for the bar chart.