Thank you, DataWolfs. The tutorial has deepened my hands-on knowledge and experience using Power BI. The content and presentation were robust and simplistic to follow.
Thank you. I love the way you created the relationship manually and also created a separate table view for the measures, this makes the measures traceable when needed for the visuals. The Date creation is also another thing I learned from your visuals. You apply a lot of DAX formulae. Replicated same process.
Yes, you are correct but if you will see we are using a date slicer in the report if you select that slicer it will show sales according to that slicer and there is another formula to replicate sales of previous year
hi, I have a question. 1.) Table shows the sales per product category per month (12) in 2022. 2.) there is a Total amount below for whole year and all product categories combined. 3.) I want to add below the TOTAL a subtotal for each product category that will show the annual sales number per each category for that year.
Hi, In real time the project starts from understanding the requirements & gathering data, this can take a lot of time, maybe 1-2 sprints. If all things are handy and clear then you can create the dashboard in maximum 3 days.
Thank you, DataWolfs. The tutorial has deepened my hands-on knowledge and experience using Power BI. The content and presentation were robust and simplistic to follow.
Thanks 🙏👍
Thank you. I love the way you created the relationship manually and also created a separate table view for the measures, this makes the measures traceable when needed for the visuals. The Date creation is also another thing I learned from your visuals. You apply a lot of DAX formulae. Replicated same process.
thank you soo much for this much information you provided for free...
Seriously the best tutorial I have ever watched 🎉 !
Thanks a lot! IT was super useful for me
Welcome 🙂
thanks a lot!
Welcome🎉
Very educating and nicely compiled 👏
Thanks 🙏👍
Excellent
waiting for more projects
Coming soon 😁
Thank you.
You're welcome! 🤗
I'd like to use this is my portfolio Sir. I'm also practicing storytelling and this looks great!
Great👍👏
@@datawolfsto ft to go to the
nice bro... pls bring more dashboards :)
Sure, thanks!!🙏❤
how Sales = SUM(Sales_Data[Sales]) is eqal to CY sales. It actually calculating sales across all the years presented in the table
Yes, you are correct but if you will see we are using a date slicer in the report if you select that slicer it will show sales according to that slicer and there is another formula to replicate sales of previous year
Good work.
Thanks❤
Great
👍
26:00 audio is very low suddenly and voice not clear also. flow is completely go on this point.
Thanks so much for the video! But, I have a problem, for calculating the Sales vs PY%, shouldn't we divide (Sales vs PY) by (Sales PY)?
Yes you do
so amazing
Thanks 😊
hi, I have a question.
1.) Table shows the sales per product category per month (12) in 2022.
2.) there is a Total amount below for whole year and all product categories combined.
3.) I want to add below the TOTAL a subtotal for each product category that will show the annual sales number per each category for that year.
Use Matrix in Reporting
As @pankaj said use Matrix
sir, what could be the possible duration in real time for doing this? is it 1 day or 1 week or1 sprint? can you pls clarify
Hi, In real time the project starts from understanding the requirements & gathering data, this can take a lot of time, maybe 1-2 sprints. If all things are handy and clear then you can create the dashboard in maximum 3 days.
Hi it's a good video and knowledgeable, but while watching the video gest hanging but the voice is hearing properly
Noted
Please complete Tutorial on DAX
hi brother which power bi desktop version you are used for this project
Latest one
Hi, i'm unable to access the dataset
Link working now please check & Happy Learning, thanks ❤
this is great but the video is blur
Change resolution from setting
at the right side bottom we have gear like icon which is settings, click on it and go to quality and select 1080p HD. Now it will not be blur
When I tried creating the first visual for sales by product and comparing it with last year sales I keep have blank for the product name
Check measure through website, if you still have problem message through Instagram
Hi, when I used Top N to filter top 5 cities, it doesn't work, which step I might be wrong?
And it also gave me a Blank city in the donut chart.
Check the pbix file shared with this video
Sir do real world project adavance level
Done new video is out
the link to download the dataset is not working
Link working now please check & Happy Learning, thanks ❤
to create the data table , where u have copied the code
In the website, link in the description section
when i try the format canvas it the format option is not highlighted do help
I am facing a similar challenge. The visualization window also seemed to have changed. Does it have to do anything with settings changes?
Click on the canvas then things then check
your website link is not working
Link working now please check & Happy Learning, thanks ❤
When I'm doing this project getting error at sales previous year
Hi it will work check for any typo error, you can also use the website to copy formula
Yeah done
Is i3 12th gen laptop with 8gb Ram enough to create such data projects???
Yes 👍
Yes go ahead to create your own project
Thank u 😊
so many lag in this vedio