Comparative Analysis Dashboard in Power BI | Step by Step Design, Data Model, DAX and Publish

[@lucazarts25]

I wonder if Indians have any idea of how Brazilians love and admire them. I had the honor to work at an Indian company (Infosys) and learn directly from these brilliant and outstanding people from India. Respect, friendship and admiration is what we have for you guys. Our culture is indeed very different, but we can appeciate and recognize the greatness in Indian people. God bless!

[@paladijagadeesh7985]

You are welcome

[@vivek1930]

Welcome , we also respect brazilian people.

[@thatgoanguy4427]

If only indian were as kind to other indians like they're to foreigners 🥲

[@rioafriyanto5208]

Yesterday was my 1st Day being exposed to PowerBI. This video is so excellent and matches perfectly to my need. I had few questions about power BI and this video answered them, plus, many of new tricks were explained nicely. I think I'm gonna watch it again to help me improve my fluency in using Power BI. Thanks Sir!

[@nipendrabulathsinghala664]

I am Sri Lankan. This video of yours is very valuable. ThankQ very much.. 🙏👏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mrittunjoyroy3246]

The way you delivered, just incredible!! Thank you..

[@PKAnExcelExpert]

Wow, thank you!

[@kaushalyarajak4839]

Thank you so much for making this video. I was struggling to create a dashboard for the same requirement for last few days and you just saved me. Thank you !

[@PKAnExcelExpert]

You are very welcome🙏

[@arpitmalviya6234]

Hats off pk sir. I came to know 4_5 new things , even after working for 1 year in powerbi

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@akshaykalamkar1545]

Where is the data for download

[@razzrazz9697]

Hi

[@kennethchukwu6018]

This video so excellent and very simple to follow especially how you used power point to create your background and your tooltip method 100%. I will look for more of you videos. Thank you.

[@PKAnExcelExpert]

Glad you enjoyed it!

[@binggg4493]

Thank you very much for sharing. So far, this is the best tutorial I have ever seen - clearly explained the nitty-gritty of each method.

[@anilkumar-vm5bd]

Thanks PK Sir for explaining step by step. I was looking for this only in KZbin.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vamshiabhilash]

Sir you have no idea how much of help was your tutorials to me especially in designing Bi dashboards I was able to land a descent job as well thank you soo so much looking forward to learn more power bi from your videos as well

[@PKAnExcelExpert]

Glad I could help!

[@rameshdurgam3589]

HONESTLY ... you're just transforming knowledge without single penny. Thank you sir

[@PKAnExcelExpert]

Most welcome

[@PrashikPatil]

Your awesome @p.k.. I follow you from last 2 years and I learned lots of new things from you. .. Thank you..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ThePunisher005]

Love this presentation, straight to the point and very informative. I have learned allot from watching. thanks allot for sharing.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vipinpalsingh9760]

@@PKAnExcelExpert ..how could we get the data for download for this dashboard..i think data is missing from the shared link

[@WalterHS2000]

Excellent video really shows how to build dashboard clearly and quickly.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@powerbis.1794]

Dear Lecturer, you are very gifted teacher thank you so much for video!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@user-ft9tp4ss2d]

WOW. Superb Sir.. Thanks you are my Guru from now onwards. Your explanation had great flow.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@user-ft9tp4ss2d]

@@PKAnExcelExpert Thanks Sir, If I hide those Tool tip pages, those tool tips will be showing in the Dashboard while highlighting those visuals?

[@PKAnExcelExpert]

Yes

[@user-ft9tp4ss2d]

@@PKAnExcelExpert Thanks Sir, Anyway I will hide that and publish, Sorry for the silly question :)

[@ailenecarreon]

This is the best tutorial I've seen on Power BI by far (and I have watched so many). Thank you so much. This is such a huge help.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@bmwslamdunk]

No other tutorial better than yours, real learnings here!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tejaswikc5370]

Excellent explanation ,Thank you so much . you have changed my perception about PowerBI

[@jaitiwari241]

Ur way of explaining concept is amazing.. Plz upload more such power bi dashboard 🙏

[@PKAnExcelExpert]

Will upload soon

[@jananiingarshal1777]

Thanks a lot and need more videos like this. You have shown as simple as anyone can understand and in a very simple language. Thanks much... please upload more on dashboards.2

[@PKAnExcelExpert]

Will upload more.. Thanks🙏

[@aswinqtpi803]

One of the best that i ever come across thank you Sir!

[@bodhanandannhattuvetty3179]

Well explained. I learned many things after watching and practicing this. Excellent effort by PK. Thank you, PK.

[@PKAnExcelExpert]

Glad it was helpful!

[@HanaaGhaly]

Hands down the best PBI tutorial ever.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vsraman85]

This is one of the best Power BI tutorial. It is very clear, simple and perfect explanations. This tutorial has clarified most of my designing doubts and this is the dashboard what i exactly looking for. Thank you so much... really good work..

[@harrydre]

Thanks for this video, I have learnt some skills that will be implemented in my next project.

[@PKAnExcelExpert]

Glad it was helpful!

[@shabnamkhan7235]

This is so amazing, thank you for sharing this with us. Keep up the good work!!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@sambhunathchakraborty]

Thanks alot Sir for Simple Presentation with great example.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sambhunathchakraborty]

Sir how "Date dim" table can be created for "April To March" or Qtr1 =April to June and so on ?

[@michaelkulbe9930]

Super Arbeit. Ich war auf deiner Site. GENIAL! Mach weiter so! Grüße aus Deutschland. Vielen Dank für die tollen Inspirationen.

[@rahulk4254]

This is Exactly What I was looking for. Thank you. Keep Posting.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@we3605]

Brilliant as always. Simple, clear, and to the point. No complex wiring anywhere. Thank you Priyendra Kumar.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@عابثالأخير-ز9ي]

Always, you are given to us a good explanation

[@debuvlogs20]

Great Video It will enough knowledge how to create any dashboard in Power BI..Thank you..Please make more video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@manishlalsah8075]

Thankyou sir , by this dashboard I learn lots of new things.

[@bittujha1571]

Worth watching your video. Keep up the great work you are doing. Thank you. :)

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@vijayt3678]

I must say you are a gem of person with clean and precise explanation about lot of topics. Thank you so much for your efforts and now we have some expectations from you in the future as well with some other topics. More power to you..

[@rochellerobinson939]

Another great course! I really like that you always provide a practice file!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mensahacquah6194]

@@PKAnExcelExpert please kindly help me with the practice file

[@RajendraPatel.]

Tooltips is awesome 💕

[@PKAnExcelExpert]

Thanks

[@Mahalakshmi_Nandhakumar10x]

Great Effort and So Informative, Thanks a lot

[@PKAnExcelExpert]

You are most welcome

[@mohdmuzammil3059]

Just one word Outstanding explanation 👌

[@zubairmushtaq7912]

Great sir please make every important type of BI Dashboard

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will try

[@danezuzu5768]

Pk you are a great teacher

[@PKAnExcelExpert]

Thanks

[@AnandSinghNoida]

Brilliantly explained every thing in a simple way, clear, and to the point. Thank you so much great Job.

[@arbazahmad7177]

Very clear explanation 👌 Thanks

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@Jimizr]

Boss you are doing an exceptional job

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Hrifudusowo]

You’re a god sent. God bless you fam!!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@MUSICA1742]

You are doing an excellent job. Thank you so much.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mzeeshans58]

Very well explained video.Keep it up thanks

[@PKAnExcelExpert]

Thanks for liking

[@mukeshpatil2]

To the point explanation. Thank you!

[@PKAnExcelExpert]

Most welcome🙏

[@pawansharma-wo3xh]

Well explained . And as always very nice explanation. Thank you so much PK You are one of the best excel expert on youtube.....

[@AshokKumar-sy2qt]

Sir you are super. you are a sun light for the users who are willing to learn new tools. :)

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SN-ty3hg]

Thank you for make detail step by step make this dashboard. Nice job !

[@PKAnExcelExpert]

Glad you liked it!

[@lynniseharrington2476]

You are amazing! This was super helpful and so easy to follow along

[@PKAnExcelExpert]

Thank you so much!

[@raushankumarpandey897]

Amazing content 👌 very informative

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@bntenza]

This is amazing dash board I have seen so far, its magic. Excellent explanation as well.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@akshaykalamkar1545]

Data for download?

[@boneswoodwrx]

Amazing! This is a huge help. Thank you for doing these tutorial videos.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ManaTelugodey]

Niec explanation..💯

[@PKAnExcelExpert]

Thanks for liking

[@KhalilAhmad74036]

You are a brilliant teacher, sir,

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@claudia-rp2xl]

Excellent . Thank you very much fir all the explications. You answer so much of my questions . Great Job

[@LokeshKumar-yi3ln]

Vary easy to follow good one..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@saransewatadul696]

That's great and very helpful. Thanks🙏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@hp7557]

Thanks for sharing 'Awesome' Dashboard....! Excellent indeed.. .. ..! Wowww

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pallavi_joseph]

Very good AND Informative

[@PKAnExcelExpert]

Thanks 🙏

[@k.manisekar1591]

Dr Ji Ur all vedios is excellent, need inventory management and accounts vedio

[@worldishere4178]

You are the best and our ideal 🥰🥰🥰

[@GauravKumar-hl8nj]

Hi Gud Morning Sir, These tutorials step by step beginners to advanced level skills are best qualities......... Plzzzz Sir Kindly request you to please provide tutorials in hindi also.....and I request you to Plz how to put more formulas and functions with tips and tricks provide more information about Excel spreadsheet maintain data analysis in Excel and Advanced Excel with dashboard........more........ mostly best tutorials........

[@Olu_boomie]

Thanks so much for sharing this PK

[@casompallipraveen860]

Thank you very much Mr.Pk I got stuck in Calender auto date which you shown in this video really appreciate

[@patipattadajan5638]

Great video I have seen the power BI so far, thank you for sharing a gread thing

[@mastanvalishaik2878]

Very much helpful. Thank you sir.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pitamberbisht5786]

This is reallly good enough. I impressed enough with tooltip which I really don't know. Thank you for sharing Awesome Dashboard!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@peternganga9371]

That's a beauty. Keep up.

[@PKAnExcelExpert]

Thanks, will do!

[@kulkarnibs8179]

Very nicely developed good 👍👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@irfanmansoori3060]

Amazing content.. thank you so much.

[@PKAnExcelExpert]

Most welcome🙏

[@nd_m75]

Very informative...clear and concise

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Arctico988]

a great video, thanks for sharing. It would be lovely to get formulas explanations as well! Keep going

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@monircseiu]

This is superb. Thank you Sir.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@AshishKumar-dc2zd]

Thanks for this Awesome Dashboard. 👌 PK bhai excellent 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nathanstamford1215]

Thank you for the video... great help

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@89veena]

Sir, you are great 🙏🏻

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dibassimohamed5514]

Thanks you a lot. I will master your video. I don't know how to thanks you. So thanks you for sharing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dibassimohamed5514]

@@PKAnExcelExpert Thank you for your reply. Just to inform you, I am learning a lot through your video, I notice out that the color mapping of YoY Sales Growth% is pointing to Budget Variance % instead of YoY Sales Growth%. Again thank you, this from far one of the best if not the way to hands-on PBI.

[@Shubham-pd9xi]

At 14:31 while Adding measure "CY Sales" , which button will lead to next row (like 1.CY sales 2.Var CY),Enter and drop down did not work .

[@dashboard1396]

Shift + enter

[@Shubham-pd9xi]

@@dashboard1396 thanks

[@yousifmohammed4841]

Lovely tool and great explanation,Sir!

[@PKAnExcelExpert]

Glad you liked it!

[@sidhantgi899]

Bhaut hee badiyaa

[@dalinpich6736]

you just saved my day Thank you very much

[@PKAnExcelExpert]

Glad I could help

[@kesavanmechanical]

REALLY HELPFUL THANKS

[@PKAnExcelExpert]

Most welcome🙏

[@raghavendrasingeetham2243]

From scratch to until Dashboard presentation it is simple and clear and concept based. Thank you for this great video. Shall i download excel file which you have used for my practice as well.

[@rico1648]

Thank you. I learned so much so fast :)

[@PKAnExcelExpert]

Glad it was helpful!

[@Kashifsiddiq22]

Great presentation.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@davidsalazarbullon7633]

Simple and amazing!!, great job with the explanation!!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@michelkant]

thanks for sharing! Great tips included.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@khaleel26dubai]

excellent. i will practice now

[@PKAnExcelExpert]

All the best

[@debbyskitchen_by_funmi]

Excellent video, very detailed!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@TiamiyuAjibola]

Thanks a lot for this educative tutorial. i would like to ask for the link to the dataset used so i can also practice as i am watching the video. thanks

[@nehabohra9689]

Thanks, I remodeled my template after seeing this.. But using CY sales example numbers in getting same numbers (total of all products) in each of them!! Could you help me out over there!!

[@shrikantbadge3978]

what a creative and different. thanks

[@PKAnExcelExpert]

Most welcome🙏

[@sandiptalekar6188]

Thanks for the tutorial. I need to add one thing that you missed to add year filter in tooltip pages

[@PKAnExcelExpert]

You can add it in that page, however in tooltip it will filter the year automatically, if it is selected on main page

[@sandiptalekar6188]

@@PKAnExcelExpert Yes we can add if wanted to. But what I am saying is that you forgot to mention the year filter as the numbers are not matching in the dashboard downloaded from the link

[@pekahon]

Gosh! I made a similar dashboard with hard way and it took weeks to collect the data. Now I know how it should have been made.

[@nupurkumar778]

Hello, thanks for the vid. I am calculating the Budget Sales same as your calc but when i put it in a table or card (like shown in the vid), it keeps giving me $3.59B for all years - I have tried filtering years or changing the formula to SUMX but i get the same result. Please can you help and why this may be the case? Same query for budget variance. Thanks!

[@farzadsaedi1954]

Fantastic, finally I found well oil. thank you