Part-3. Power BI Desktop Essentials: Designing a Dashboard for Drug Sales Analysis.
If crafting dynamic and interactive reports and dashboards using Power BI Desktop is on your learning list, this YouTube video is tailor-made for you.
Don't forget to subscribe for more dashboards. Thank you.
Download Custom Map here: https://github.com/topojson/world-atlas?tab=readme-ov-file
Watch part-2 here: https://youtu.be/ovQ9czcvotk
Download the dataset here: https://drive.google.com/file/d/1Sr0AimoF1WVBrCdZXhfgvwvPYPyy4k0d/view?usp=sharing
Access the full Dashboard PBIX here: https://www.udemy.com/course/unlocking-dax-secrets-elevate-your-dashboard-design/?referralCode=0C933044E5A02FA8595D
✔ If you need me to create your Dashboard send WhatsApp Message to: +234 810 6090 365 Business only.
00:00 - Intro and Dashboard Task in PDF
01:39 - Overview of our next project
03:29 - Understanding the Tables to include in our Dynamic Titles
05:41 - Creating Dynamic Title for Top/Bottom Drugs sold (DAX)
18:37 - Formatting our charts
33:09 - Add percentage of the dynamaic Tand BottomN on view (DAX)
1:01:12 - Create DAX to show the values of the dynamic TopN and BottomN Selected (DAX)
1:17:03 - Create Dynamic Top and BottomN for Customers (DAX)
1:27:42 - Dynamic Title for Top/Bottom Customer (DAX)
1:34:43 - Percentage and values for Top/Bottom Customers (DAX)
1:49:30 - Bookmarking our Slicers for Hide and show