📁 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
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?
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.
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 .
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?
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?
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.
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
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
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.
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 😊
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
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
Indian teachers are the best. 👍
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 !
That was quick, concise and qualitative. Thanks for sharing such knowledge brother..!
but ctrl+/ isn't working but why ??
Excellent, am big fan of your tutorials. The way you teaching is fantastic, i do watching your other videos
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
I am glad that I found this awesome channel
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.
Pawan sir...
I am really sort of words here..
Amazing !
❤ From Bangladesh 🇧🇩
I will never forget you my friend a lot of thanks to you...
@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
Sir, very useful video. You make everything look so easy 🙏
Thank you so much.
Thank you so much. You were so detailed in a simple and easy to understand way.
Glad it helped!
Wow Bro, that's Awesome. I am breathless and inspired. Keep Up the Excellent Work Bro. 👏😊
Very nice video. Is there any option of getting your help in case stuck with project work related to power bi
funniest but clear instruction. Thank you sire
Thanku, please share more vedios about creating dashboard in less time
1st tutorial which works succesfully after following. Thankyou soooooooooooo muchhhhhhhhhh
Thank you so much for the wonderful tutorial
🙂
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?
Thank You so much Bro
Mind blowing video!
Good tutorial 👍
Your amazing, appreciate that ❤
Thanks for making me look like a genius
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
Thanks for this great content 🙏🏽
very nicely explain some really complex looking report😊
excellent, great work, you are star.
Your tutorials are topnotch kindly do a video on dax query view sir i love your tutorials. Thanks
Useful tutor
really appreciate your work......hats off to you sir......
This is amazing stuff! THANK YOU!
That's Great sir thank u so much
Nice trick. Can I do it with "measures" instead of "columns"?
Good explain sir
Great video, thanks
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 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
Very very Thankful to you for this wonderful video.
Encellent❤
Hi for the maps can it go as detailed as city boundaries?
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.
Thank you sir for sharing the amazing information. Please make tutorial on Tableau - LODs topic.
All should hail down to you ⚡
Where can I download power bi software?
Thank You Sir!
Impressive and amazing
Thanks 😊
You are good
GREAT SIR
Awesome sir
Nice . ❤❤❤ 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 .
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?
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
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.
is it possible to analyse two years data in the power bi
if so how to do it
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
Nice one.. Thank you in advance
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
Please make a vedio on excel also with short cut key to create a dashboard
i am not to extract google sheet in to power bi, how can i do that
how to create a live feed ticker graph .. example in stock exchange or money exchange there is a live feeder
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
Who came here after Learn With Giggs LinkedIn Post about this video : Create Power BI Report in 7 mins
In my power BI not display chart short cut after ctrl+/
why order date sales line was not formed in my dashboard??
" 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.
EXLENT
can u share the difference btw dashboard and report
how can we download the dataset in csv format
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
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.
Ctrl+/ not work for me 😢
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.
How will I contact you? I need help in creating a Dashboard related to IT Services
How to enable map setting is Power BI
How to remove "K' or "M" from the values that Power BI sums round off?
Where is the link ?
Who to download a data which is used in this vidio ?
I want to Practice
Sir, dax tutorial class required..... Please beg you
It's only in view mode.. Can't use
Hi can you please provide online training?
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 😊
For me CTR+/ is not working?
excel file link is not working properly
hello mr pavan, i want to attempt pl/300 exam , can u tell me how can i prepare for it
I am using a Mac and the suggestions do not appear in Q&A section. Does anyone know the reason?
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 !!!
PLEASE UPLOAD YOUR DAX TUTOTIALS SIR PLZ FULL BASIC TO ADVANCED DAX PLEASE SIR
4:19 Where is okay button
Sir the map is not accessible for me . Please help