📁 Excel practice file :- docs.google.com/spreadsheets/d/1RlVvP3N9j4mvdTYtPLeuPzOpcpchNRfq/edit?usp=sharing&ouid=110443835961242012762&rtpof=true&sd=true 🧑🎓 Power BI course Link :- learn.pavanlalwani.com/courses/Power-BI-2023-63a05686e4b0a7b1ab4dfc8d
I'm drooling in awe at the creativity used here. This is such a great tutorial! The main challenge is that you should have a base data which needs to be cleaned and scrummed. That's 80% of your time spent in preparing the report, but this video provides a quick insight into the process that makes it all worth it. Thank you so much!
Your video is a "Sanjeevani" for the newbie "Data Analysts". The way you made this video is highly commendable. And in the end, your message to all those bosses is an ultimate icing😅
Wowwww, really interesting, thank you for sharing such informative topics you're wonderful instructor, i am following from years, by watching your videos i was able to automate couple of reports using power query, for that i awarded Global Operational Excellence Award -2024 from my organization, Thank you so mcuh for your valuable topics.
The first step before creating a dashboard is to clean the data Sir, Make video how to clean the data if we have thousand of observations of the business requirements
Thanks sir, for your detailed information about power bi concepts. I've one doubt, while pasting certain images from previous report to newly fitted ppt report on canvas view ,how to make those pasted images look naturally fitted in those boxes. Well In updated version of power bi UI , there are only 2 options: callout value & category label. In this video timings (11:54)Size & style option is not available. How can i make them look natural in the report sir?
Thank you for this tutorial, here i am facing problem in getting reports, i am not getting visuals of report, its showing too many values in sales what to do? please help
Sir , how we can change the color to filtered column which is inheriting color from first graph. Normal format column color change is not working because we have selected legend as Region. Could you please guide on this .
I have a date column in a hierarchy format (e.g., Year-Month-Day). In a matrix visual in Power BI, I've placed the category in rows, date in columns, and total order value in the values section. Now, I want to create a visual where, when someone clicks on a particular month in a slicer, only that month's data drills down to the day level, while the data for other months remains at the month level. For example, I have data from January to December, and currently, the data is presented at the month level. When I select March in the slicer, I want only March's data to drill down to the day level, and the data for other months to remain at the month level. How can I achieve this formatting in Power BI?
While creating a dashboard I'm facing a problem that while dragging the sales to dashboard instead of creating the sales card like in your video it is creating a column chart. Can you please help me in resolving this issue?
Hello, Please, I have one data file for my practice that I need your support in visualizing as a beginner, how can you help me. Thanks and greetings from Nigeria
can you help with these conditions in power Bi Transformations; Row 1- Schedule: Baseline Start Date. This should be in Black color. If there is no Baseline date, then leave the field blank Row 2- If there is no Baseline Start Date in Row 1, then Row 2 should be blank. If there is a Baseline Start Date in Row 1, then the following conditions apply: If ‘Schedule task % Complete’ = 100%, then input Actual Finish Date. This should be in Blue color. If Schedule task % Complete < 100% then input Schedule: Start Date - Task. If the date is in the Past (as compared to today), it should be in Red font. If the date is in the future (as compared to today), it should be in Green font.
Please upload dax tutorial video.. sir it will very useful for all viewers who regularly follow ur video... with dedication..its need full sir.. This video is amazing for students as usual u are... Thank u sir 😊
Hi Pavan, I have installed Power BI September 23 version in my desktop but it is not working Ctrl+/ function. Please help me to know how I can activate this. Thanks in advance.
The video length is enough for me to determine whether you have taught me what you said you would in 7minutes, we don't need an onscreen timer with sound effects for you to prove your point. The timer ticking away is distracting and this tutorial is worse off for it. Otherwise the tutorial content was good.
But for making it in a 7 min , one should have to know the names of all chart and which chart to add in which condition, which chart is best for which data then only we can do it
📁 Excel practice file :- docs.google.com/spreadsheets/d/1RlVvP3N9j4mvdTYtPLeuPzOpcpchNRfq/edit?usp=sharing&ouid=110443835961242012762&rtpof=true&sd=true
🧑🎓 Power BI course Link :- learn.pavanlalwani.com/courses/Power-BI-2023-63a05686e4b0a7b1ab4dfc8d
Great, thanks for sharing.
Can't open the sheet sir ,it still showing wrong url
Indian teachers are the best. 👍
All this time, I thought Power BI dashboard backgrounds were created in Power BI, but they're actually created in PowerPoint. Thank you so much.
Thank you very much sir. I’ve gotten soo much value than I could ever imagine
Your Welcome
I'm drooling in awe at the creativity used here. This is such a great tutorial! The main challenge is that you should have a base data which needs to be cleaned and scrummed. That's 80% of your time spent in preparing the report, but this video provides a quick insight into the process that makes it all worth it. Thank you so much!
Just wow man, I am just learning Power BI and this video is just mind blowing - Thank you for such great insight !
Your video is a "Sanjeevani" for the newbie "Data Analysts".
The way you made this video is highly commendable.
And in the end, your message to all those bosses is an ultimate icing😅
Something new word I heard after long time
Excellent, am big fan of your tutorials. The way you teaching is fantastic, i do watching your other videos
Pawan sir...
I am really sort of words here..
Amazing !
That was quick, concise and qualitative. Thanks for sharing such knowledge brother..!
but ctrl+/ isn't working but why ??
Wowwww, really interesting, thank you for sharing such informative topics you're wonderful instructor, i am following from years, by watching your videos i was able to automate couple of reports using power query, for that i awarded Global Operational Excellence Award -2024 from my organization, Thank you so mcuh for your valuable topics.
❤ From Bangladesh 🇧🇩
I will never forget you my friend a lot of thanks to you...
Thanks for making me look like a genius
@pavanlalwani sir, I seen your excel videos from tutorial point. Its very amazing explanation great thanks to you and u r excel guru Learning excel❤❤❤
Excellent .. Very concise and to the point.
The first step before creating a dashboard is to clean the data
Sir,
Make video how to clean the data if we have thousand of observations of the business requirements
funniest but clear instruction. Thank you sire
Wow Bro, that's Awesome. I am breathless and inspired. Keep Up the Excellent Work Bro. 👏😊
Sir, very useful video. You make everything look so easy 🙏
Your amazing, appreciate that ❤
Thank you so much. You were so detailed in a simple and easy to understand way.
Glad it helped!
Thanku, please share more vedios about creating dashboard in less time
Very nice video. Is there any option of getting your help in case stuck with project work related to power bi
Thank you so much for the wonderful tutorial
🙂
Useful tutor
Encellent❤
1st tutorial which works succesfully after following. Thankyou soooooooooooo muchhhhhhhhhh
Very very Thankful to you for this wonderful video.
Thanks for this great content 🙏🏽
Thank you so much.
Mind blowing video!
Your tutorials are topnotch kindly do a video on dax query view sir i love your tutorials. Thanks
This is amazing stuff! THANK YOU!
All should hail down to you ⚡
excellent, great work, you are star.
Where can I download power bi software?
Hi for the maps can it go as detailed as city boundaries?
Good tutorial 👍
very nicely explain some really complex looking report😊
Nice one.. Thank you in advance
really appreciate your work......hats off to you sir......
Thanks sir, for your detailed information about power bi concepts.
I've one doubt, while pasting certain images from previous report to newly fitted ppt report on canvas view ,how to make those pasted images look naturally fitted in those boxes. Well In updated version of power bi UI , there are only 2 options: callout value & category label.
In this video timings (11:54)Size & style option is not available. How can i make them look natural in the report sir?
Nice . ❤❤❤ sir
That's Great sir thank u so much
Nice trick. Can I do it with "measures" instead of "columns"?
Thank You so much Bro
" Ctrl + / " Save ton's of time
What is Ctrl+/ used for
??
It's QandA box. Other shortcut is double click on screen
Yes sir just now saw this complete video. Really thank you.
Good explain sir
is it possible to analyse two years data in the power bi
if so how to do it
Impressive and amazing
Who came here after Learn With Giggs LinkedIn Post about this video : Create Power BI Report in 7 mins
Great video, thanks
You are good
Thank you for this tutorial, here i am facing problem in getting reports, i am not getting visuals of report, its showing too many values in sales what to do? please help
Thank you sir for sharing the amazing information. Please make tutorial on Tableau - LODs topic.
how to create a live feed ticker graph .. example in stock exchange or money exchange there is a live feeder
Hi, when I'm dragging sales, profit,etc.. I am getting in the form of bar graph not in numbers
After drag drop choose the number/card chart from visualization section. Bar will change to card
Awesome sir
Sir , how we can change the color to filtered column which is inheriting color from first graph. Normal format column color change is not working because we have selected legend as Region. Could you please guide on this .
Thank You Sir!
I have a date column in a hierarchy format (e.g., Year-Month-Day). In a matrix visual in Power BI, I've placed the category in rows, date in columns, and total order value in the values section. Now, I want to create a visual where, when someone clicks on a particular month in a slicer, only that month's data drills down to the day level, while the data for other months remains at the month level.
For example, I have data from January to December, and currently, the data is presented at the month level. When I select March in the slicer, I want only March's data to drill down to the day level, and the data for other months to remain at the month level.
How can I achieve this formatting in Power BI?
Thanks 😊
GREAT SIR
Please make a vedio on excel also with short cut key to create a dashboard
thanks for ur reply carrier gap 3 years i see all ur videos sir is that good option to switch carrier to data analysis is good or bad sir
Good Option but you would need to start as fresher
@PavanLalwani fresher also getting above 30,000 or more?
Yes and No
Depends on interview/company/candidate/location.
can u share the difference btw dashboard and report
While creating a dashboard I'm facing a problem that while dragging the sales to dashboard instead of creating the sales card like in your video it is creating a column chart. Can you please help me in resolving this issue?
Click on Ur card first before u drag
When you enter ctrl+/. You got questions box with suggest a visual. I got question box. But I didn't get suggest a visual I have a update version
Hi can you please provide online training?
Hi Pavan sir, I wanted to create a dashboard on yearly cash flow statement, but was facing problems in data. Can you help me out
how can we download the dataset in csv format
Hello, Please, I have one data file for my practice that I need your support in visualizing as a beginner, how can you help me.
Thanks and greetings from Nigeria
Sir, dax tutorial class required..... Please beg you
EXLENT
i am not to extract google sheet in to power bi, how can i do that
I came for a dashboard and you showed me report. not fair !!!
I can't connect Google sheet to power bi. Could you pls share a video on this.
How converting Excel to refresh in Power BI
can you help with these conditions in power Bi Transformations;
Row 1-
Schedule: Baseline Start Date. This should be in Black color. If there is no Baseline date, then leave the field blank
Row 2-
If there is no Baseline Start Date in Row 1, then Row 2 should be blank.
If there is a Baseline Start Date in Row 1, then the following conditions apply:
If ‘Schedule task % Complete’ = 100%, then input Actual Finish Date. This should be in Blue color.
If Schedule task % Complete < 100% then input Schedule: Start Date - Task.
If the date is in the Past (as compared to today), it should be in Red font.
If the date is in the future (as compared to today), it should be in Green font.
Please upload dax tutorial video.. sir it will very useful for all viewers who regularly follow ur video... with dedication..its need full sir..
This video is amazing for students as usual u are...
Thank u sir 😊
Hi Pavan, I have installed Power BI September 23 version in my desktop but it is not working Ctrl+/ function.
Please help me to know how I can activate this.
Thanks in advance.
Double click on screen
Where is the link ?
Who to download a data which is used in this vidio ?
I want to Practice
The video length is enough for me to determine whether you have taught me what you said you would in 7minutes, we don't need an onscreen timer with sound effects for you to prove your point. The timer ticking away is distracting and this tutorial is worse off for it. Otherwise the tutorial content was good.
4:19 Where is okay button
why order date sales line was not formed in my dashboard??
hello mr pavan, i want to attempt pl/300 exam , can u tell me how can i prepare for it
PLEASE UPLOAD YOUR DAX TUTOTIALS SIR PLZ FULL BASIC TO ADVANCED DAX PLEASE SIR
How to enable map setting is Power BI
How much can earn after learn excel
please make a video on how to make graph having plan % . cummulative plan %. Actual % and cumm. actual %
Thank you for your feedback. We will certainly consider your recommendation.
How can I use the same excel sheet
I want to be rude towards you but I'd let it slide. Check the description box. There's a drive link to that file; you can download it from there.
Oh and also he pinned a comment which has a link to that excel sheet.......YOU DORK!
excel file link is not working properly
In my power BI not display chart short cut after ctrl+/
First comment❤❤❤
Hi sir can you please do projects on hr recruitment dashboard
Sir give me link of raw data that used in power bi
Search in google Superstore data.xlsx
@@PavanLalwani ok sir ❤
But for making it in a 7 min , one should have to know the names of all chart and which chart to add in which condition, which chart is best for which data then only we can do it
Agreed !!!
It's only in view mode.. Can't use
How to remove "K' or "M" from the values that Power BI sums round off?