You are a Pro really... The way you made the background shows intensive level of planning and smartness , I am very delighted I got this channel here . Your work and arrangements, are - something I should admire and say thanks for this marvelous video really.
Thank you for the video. I had a small question: How do I proceed if I remove all filters and want my cards and visuals to display data for the last month instead of the cumulative data for the entire year ?
Thanks a lot for your instruction, btw can you share about the color pallets that you applied for Power BI? I dunno how to choose color wisely to apply for each background. Thanks.
Hi . Profit margin . i d have said profit divided by sales(or sum of total selling value ....but i believe you said profit /sum(total buying value)... thats mark up at 4:22
@@LeanExcelSolutions I am not sure because I am learning Power BI from your amazing videos...but at 4:02 when I tried your calculation for Profit = SUM ([Total Selling Value]) - SUM (Total Buying Value]) I was getting same values for alllll entries in this new column (Profit) . So I changed it to [Total Selling Value] -[TotalBuying Value] . btw thank you so much for your videos..I have never learned so much in such short time
great video! love it. i have a question. at 5:34 when i try to add the total selling value. why did my power bi change it to ''sum of total selling value''. i try to delete/choose only for ''total selling value'' but the option isn't there. How do i solve this? please help me 😭
thank you but may i know one thing the data you shows in the starting so that means we only need these informations in power bi if we are creating sales dashboard please answer because i always get confused here
Hi, you can download the data file I mentioned at the beginning. Link is in the description to download. I already have covered this data file explanation in the earlier Sales Dashboard in Excel tutorial. That's why I skipped it here, you may watch that too for more details.
at 3:26 when i do the same measure the app show message "A single value for column 'QUANTITY' in table 'InputData' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as ...etc" how can i solve this i hope u read my comment
Hey can you share me the colours you used for background i want to make another project of mine with the same theme and template please help me out i am unable to edit your template
Thanks for this tutorial. my dashboard looks amazing. However I have a problem, when i change computer with a smaller screen the background doesn't feet anymore. Do you have any solution to fix this issue?
Hi, it is explained step by step in Excel dashboard version (please watch sales dashboard in Excel tutorial) & also link to download background image is in the description!
Hi, Thanks for sharing this. I do have one question or a sample based from the dashboard you have shown. Let's say in the month slicer I chose Jan and in the year slicer to 2022. In the bar graph visual, I wanted to show the 12 month roll of data so technically, what I wanted to show in there will be from Jan 2021 until Jan 2022 only. For the card visuals, in here it will only show the Jan 2022 data since that is what I've chosen in the slicer. May I ask how we can achieve that in one sheet. Or maybe you have a video tutorial on that? Thanks
According to me, you can use a slicer in different ways. Simply you need to select slicer and put the date in a field where you will get an option to select a date range. It will work for you. Please let me know does it works for you or not. 😊
@@LeanExcelSolutions hmm when I click on the link I get thousands of weird signs like:"PK�����!�KªN-†��Œ���[Content_Types].xml ¢( ���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������ÄUÉnÂ0...." This is how it should look like? :D If yes, what I should do with it?
One more problem I have faced in this background is when I'm going to convert IN pdf by export pdf it is disappearing the background so what to do in such case Plss reply. And this video is really awesome I have also shared with my several friends.
Thank you for your appreciation! At my end, the export to PDF option appears to be working; however, I am not sure why it is not working at your end. Please try printing (Ctrl+P) and saving it as a PDF.
Hi i installed mysql connector and also install odbc connector but till power bi showing error connector need one or more components.... Error. I have 64 bit system plz help me in this. Thank you
When I merge the two tables there are columns who have the "value" : null. I don't know how to fix this, since the two tables don't have the same number of lines ? Can someone please explain to me what iam doing wrong
I tried it...but it seems Power Bi only reads data in columns. Need to create a new tab in my file to flip my rows and columns and into a table. I mean my own datasheet that is made for ppl to enter values.
Dear Sir, I kindly request you to share the data, as it will help beginners like me practice and improve. I appreciate your video - it is very informative. However, I understand that sharing data is your choice. While we can watch your video and learn from it, there are many other videos available on this topic. I believe that knowledge and income are two different things. I kindly request you to reconsider sharing the data. Regards, Faisal
@@LeanExcelSolutions i think we have to pay for downloading the data set as well. which is why you guys are making money. please provide data set at free of cost.
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
I love data visualization. I've been working with Power BI by 4 years and still enjoy it.
Great to hear!
What is the first thing you do when a data is given to you? (Asking for Help)
ruclips.net/video/F2GY5U-uVhI/видео.html
What is your job?
Hi bro any job vacancy available kindly let me know i love power bi
I bought the file for $5 But learned $5000 worth of course. Thank you so much
Much appreciated
I already know how to use PowerBI, but I found this video very satisfying to watch, keep it up!
Much appreciated your kind words. Thank you!
You are a Pro really... The way you made the background shows intensive level of planning and smartness , I am very delighted I got this channel here . Your work and arrangements, are - something I should admire and say thanks for this marvelous video really.
Thank you so much for your appreciation 😀
Thank you so much for sharing this. I made dashboard through this quick video. Continue making such videos on power bi and excel dashboards
Thanks 🙏
Really amazing vedio. You are excellent nice explanation. Working style really appreciated 👌
Thank you so much for the appreciation 😊
Thanks for sharing all the tips and tricks!
👍
This is a very useful one.... I have shared it in LinkedIn
Thank you,😊🙏
That sound in the background reminded me of The Sims. Thank you for sharing this!
Nicely explained. Helpful for beginners to prepare dashboard.
Happy to hear that 😊
Thank you!
OMG, awesome!!!!
Even without fluent english I saw that I can learn.
thank you very much for share your knowledge.
Thank you for appreciation 😊
ruclips.net/video/F2GY5U-uVhI/видео.html
Thanks, it is a concise elaboration, superb
😊
Concise, to the point and very helpful. You just gained a new subscriber.. Thank you
Thank you very much! 😊
great, We need more about Power Bi
Yes, sure!
All clear, in a simple way
🙏 Thanks!
your instruction is very helpful, thank you!
Glad to hear that 😊
Thank you very much. Awesome tutorial with well explanation.
Thanks!
ruclips.net/video/F2GY5U-uVhI/видео.html
Seriously amazing ❤
I watched this video at speed of 0.75 😂
Thank you 👍
seamless! thank you. kindly upload more vids.
Thank you, I will
ruclips.net/video/F2GY5U-uVhI/видео.html
I really appreciate the video you shared! Thanks a lot! 🎥😄
My pleasure 😌
Amazing job! Thank you very much. I did my second pbix dashboard file with your tutorial it help me a lot!
Well done & thank you for appreciation!
Hi Francisco, do you mind sharing your project? I'm facing some issues.
Great content, keep posting
Thank a lot!
Definately, will add more!
clear instruction and really learn a lot from the video.thank you!
Glad it was helpful!
ruclips.net/video/F2GY5U-uVhI/видео.html
Muito obrigadoooooo😊😊😊❤🎉
Most welcome 🤗
very informative, pushes me to learn more..
Glad to hear that! Thank you :)
What a great video!
Thanks 😊
Thanks for this tutorial and source files 😃
You're welcome 😊
Great Power BI videos. They are really helpful and interesting to watch. Thank you for sharing
Glad you like them!
ruclips.net/video/F2GY5U-uVhI/видео.html
Excellent video. Short and sweet. Please give us more design tips i.e theme colours, how to PowerPoint design.
👍
ruclips.net/video/F2GY5U-uVhI/видео.html
Thank you for the video. I had a small question: How do I proceed if I remove all filters and want my cards and visuals to display data for the last month instead of the cumulative data for the entire year ?
Super job. Would like to see a Financial Analysis project too. Thank you.
Thank you so much!😊
Sure will work on financial project too!
ruclips.net/video/F2GY5U-uVhI/видео.html
Wow! My job security just went way up!
Great
Very informative! Thank you
Most welcome!
Great video. thank you
Most welcome!
Thanks a lot for your instruction, btw can you share about the color pallets that you applied for Power BI? I dunno how to choose color wisely to apply for each background. Thanks.
Hey friend what software program do you use to record what you do on PC screen and also to talk to and also save in video format ?
Thank you so much! Really great work!!
Glad you like it!
Hi . Profit margin . i d have said profit divided by sales(or sum of total selling value ....but i believe you said profit /sum(total buying value)... thats mark up at 4:22
Yes, thanks for correction. I didn't noticed that & I think that was the mistake!
This is so good. Thank you!
You're welcome! 😊
excellent mam its like amazing thanks for your support
Thanks and welcome! 😊
The video is very good informative and I subscribed too also but the real time work also same like this?
Yes, absolutely
amazing very easy to understand!
Thanks 👍
amazing video....just one issue...i think Profit = [Total Selling Value] -[TotalBuying Value]
Thanks!
That's right. Did I mentioned something wrong?
@@LeanExcelSolutions I am not sure because I am learning Power BI from your amazing videos...but at 4:02 when I tried your calculation for Profit = SUM ([Total Selling Value]) - SUM (Total Buying Value]) I was getting same values for alllll entries in this new column (Profit) . So I changed it to [Total Selling Value] -[TotalBuying Value] . btw thank you so much for your videos..I have never learned so much in such short time
great video! love it. i have a question. at 5:34 when i try to add the total selling value. why did my power bi change it to ''sum of total selling value''. i try to delete/choose only for ''total selling value'' but the option isn't there. How do i solve this? please help me 😭
Right click on the Sum of total selling and select don't summarise. Power BI by default consider take aggregate value for numeric column.
@@abhishekkumarsingh3289there is no option like don't summarise
Amazing!
Thank you 😊
thank you but may i know one thing the data you shows in the starting so that means we only need these informations in power bi if we are creating sales dashboard
please answer because i always get confused here
Hi, you can download the data file I mentioned at the beginning. Link is in the description to download.
I already have covered this data file explanation in the earlier Sales Dashboard in Excel tutorial. That's why I skipped it here, you may watch that too for more details.
And that is the only data you need to create this dashboard
Can I use this model for everyday report sales? 😮
Thank You!
You're welcome!
I love you wala thank you 😅😅😅😅
😃😍
Nice works
Thank you very much
Love your work but please slow Down a bit
Sure, thanks!
Hey any chance you can share the powerpoint format of the background image ?
at 3:26 when i do the same measure the app show message "A single value for column 'QUANTITY' in table 'InputData' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as ...etc" how can i solve this i hope u read my comment
Use ADD NEW COLUMN instead of NEW MEASURE, bcoz Measure needs to start with aggregated function
if i may can you please share to us the power point file where the background and colors
Hi, added background image download link in description.
Hey can you share me the colours you used for background i want to make another project of mine with the same theme and template please help me out i am unable to edit your template
Please share the data set link.
Hi, it's already there in the description.
But it is not adaptive, right? What will happen if I open it on a smartphone?
Thanks for this tutorial. my dashboard looks amazing. However I have a problem, when i change computer with a smaller screen the background doesn't feet anymore. Do you have any solution to fix this issue?
ruclips.net/video/F2GY5U-uVhI/видео.html
I m the new I like your video to do the practice I need data set will
Link to download dataset is in the description!
I have a doubt mam , I wants to know what are the contents that needs to be analyse and visualize from the data in power bi
Kindly provide a step by step for creating the template background that will be using in POWER BI dashboard or maybe a link. Thank You
Hi, it is explained step by step in Excel dashboard version (please watch sales dashboard in Excel tutorial) & also link to download background image is in the description!
hello! is there any way that I can get the power point file? I may need to adjust some of the things in the background
Hi, You can download it from store. Link is in the description.
@@LeanExcelSolutions hi! i only saw the background image not the power point. I want to modify something
i love it
Glad to hear that! 😊
there is something wrong when you calculate profit % you should calc profit / total sales not buying and thank you for
your efforts
Ok, will check
Hi,
Thanks for sharing this. I do have one question or a sample based from the dashboard you have shown. Let's say in the month slicer I chose Jan and in the year slicer to 2022. In the bar graph visual, I wanted to show the 12 month roll of data so technically, what I wanted to show in there will be from Jan 2021 until Jan 2022 only. For the card visuals, in here it will only show the Jan 2022 data since that is what I've chosen in the slicer. May I ask how we can achieve that in one sheet. Or maybe you have a video tutorial on that? Thanks
According to me, you can use a slicer in different ways. Simply you need to select slicer and put the date in a field where you will get an option to select a date range. It will work for you. Please let me know does it works for you or not. 😊
ruclips.net/video/F2GY5U-uVhI/видео.html
nice review keep up !!
plz share the dataset i cant acces from the decription
Thank you :)
Here is the link to download the practice file: leanexcelsolutions.com/wp-content/uploads/2022/04/Sales-Dashboard-practice-file.xlsx
@@LeanExcelSolutions Hi, this link is not working anymore. Could you upload once again please?
Hi, I just checked it & it is working 🙂
@@LeanExcelSolutions hmm when I click on the link I get thousands of weird signs like:"PK�����!�KªN-†��Œ���[Content_Types].xml ¢( ���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������ÄUÉnÂ0...." This is how it should look like? :D If yes, what I should do with it?
Hello, Kindly Help With The Sales Data Used For This Project
Hi, the link is in the description to download practice file. Thanks!
@@LeanExcelSolutions Seen…. Not Free? Must Be Paid For?
@@Megtheanalyst_ data file is free there
cool, can you please share the excel sheets used ................Thank you for sharing
Thanks, the link to download the Excel sheets used in the description. You can download it from there.
how to get this file, because didn't exist in the link, and thanks
Very nice
Thank you
How do I get the dataset, to practice?
The link is in the description to download it.
One more problem I have faced in this background is when I'm going to convert IN pdf by export pdf it is disappearing the background so what to do in such case Plss reply.
And this video is really awesome I have also shared with my several friends.
Thank you for your appreciation!
At my end, the export to PDF option appears to be working; however, I am not sure why it is not working at your end. Please try printing (Ctrl+P) and saving it as a PDF.
Upload your pbix file to power bi service and share the link free. See in youtube how do that
@@LeanExcelSolutions thank you so much
@@waldoh thank you so much
Hi i installed mysql connector and also install odbc connector but till power bi showing error connector need one or more components.... Error. I have 64 bit system plz help me in this. Thank you
While calculating the Total selling cost, why did we use 1 minus to the discount section?
Nice
Thanks 👍
Hello sir can I get all dashboard data folder or file link.tq sir
Hi, the link to download the input data sheet is in the description.
Is the free version fully functional? Thanks
Where Can I find those backgrouns
can I put power BI into a website so everyone can access it?
You cannot select 'list' and other options in the latest Power BI. How to go about it, please?
Hi, do you mean the Slicer List?
hey amazing video.
Can you share pptx document
Thanks, the link to download the background image is in the description. Will share the pptx file soon!
Share please :)
@@LeanExcelSolutions Hi There, have you shred the pptx link ?
When I merge the two tables there are columns who have the "value" : null. I don't know how to fix this, since the two tables don't have the same number of lines ? Can someone please explain to me what iam doing wrong
I tried it...but it seems Power Bi only reads data in columns.
Need to create a new tab in my file to flip my rows and columns and into a table.
I mean my own datasheet that is made for ppl to enter values.
Dear Sir,
I kindly request you to share the data, as it will help beginners like me practice and improve. I appreciate your video - it is very informative. However, I understand that sharing data is your choice.
While we can watch your video and learn from it, there are many other videos available on this topic. I believe that knowledge and income are two different things.
I kindly request you to reconsider sharing the data.
Regards,
Faisal
Hi Faisal,
Link to download input dataset is in the video description. You can download it and build the dashboard following the tutorial. Thanks 👍
very good video but background music is dominating cannot concentrate what you are telling i have reversed many times
thank you for video
Doubt: how can I calculate top product, I am using Card but there is no filter of top N things.
ruclips.net/video/F2GY5U-uVhI/видео.html
Can we get the dataset you used
Hi, it is already there. Please check the video discription, you can find link to download it.
Please, why are you using the average profit inside total profit? and the average profit percentage inside the total profit percentage?
Hi, I think for both total profit & percentage, I have used sum only, not average.
Thank you
Please provide the link of the dataset
Hi, it's already there, the link is in the description to download it.
Hey, please use a cursor highlighter because its very difficult to follow/find on what you clicking since the video/ you are doing it quite fast
Sure, will take care of that
my teacher also told me to work on this program but it is very difficult😭
😂 Thank you for the comment, but it is not that much difficult, if you know power BI little bit!
@@LeanExcelSolutions but I don't know🤣
how can i download the dashboard
Assalamaalikum sir
Can you please share a direct link to the data source used in this dashboard? That would be really helpful
It is already there in the description!
ruclips.net/video/F2GY5U-uVhI/видео.html
@@LeanExcelSolutions i think we have to pay for downloading the data set as well. which is why you guys are making money. please provide data set at free of cost.
Hi the dataset is free, please check the link
Awesome video! Thanks for the uploading! But, the title is misleading - isn't that a Power BI report other than a dashboard?
How do you differentiate the 2? :)
🤔 Sorry, I don't get it!
It is a report indeed. But if you have pro or premium you can turn it into a dashboard.
Yes, thanks!
Please give us background design video link
Hi, it's in the "Sales dashboard in Excel" video. Here is the link for it
ruclips.net/video/bjLIA1vSqGs/видео.html
Great video but a little too fast to follow by beginners.
Thank you so much for your appreciation!
Yes, it fast for beginners. I am trying to keep it slower for new videos.
what is the dimension of this dashboard ?
16:9, (1920:1080) the default power bi canvas size
I can't open the Common Practice file in excel.
How can i download, Excel sales data.?
The link to download it is in the description.
@@LeanExcelSolutions thanks for that. Very useful video. Keep it posted realtime scenarios
Thank you 🙏