Creating Impactful Top N vs Others Visualizations using Power BI - Workout Wednesday Special
In this tutorial, we dive into the fascinating world of Power BI, focusing on creating a compelling "Top N vs Others" data visualization. This video is perfect for anyone looking to enhance their data analytics skills by learning how to implement advanced DAX techniques.
I'll walk you through the process of using SQLBI's "TopN vs Others" DAX pattern, combined with Fowmy's dynamic bar chart visualization. Along the way, we'll discuss common pitfalls and the importance of fully understanding the problem and the solution, rather than simply copying and pasting code. You'll learn how to create a Year-To-Date (YTD) pattern, set up measures like Sales YTD, Sales PYTD, and tailor them for TopN and Others categories.
By the end of this tutorial, you'll be equipped with the knowledge to not only replicate these techniques but also customize them to suit your unique data scenarios. Whether you're a beginner or an advanced user, this tutorial offers valuable insights to enhance your Power BI skills.
Don't forget to like, subscribe, and comment if you found this video helpful. Links to the resources and demo files mentioned are in the description.
Let's dive in and create impactful data visualizations together!
Roland
🔗 LINKS:
SQLBI TopN vs Others Blog - https://www.sqlbi.com/articles/filter...
ExcelFort DataViz - • Effective Growth Visualization: Basic...
Data Stories Gallery - https://community.fabric.microsoft.co...
Workout Wednesday - https://workout-wednesday.com/2024-we...
🎬 MORE VIDEOS:
Fully Automated Power BI Access Management Tool using Power Apps and Power Automate - Part I - • Fully Automated Power BI Access Manag...
Power BI & Power Automate - How to automate reporting process -
• Power BI & Power Automate - How to au...
Dynamic Row-level Security 🔐 - Based on Dimension Tables - • Dynamic Row-level Security 🔐 - Based ...
Chapters:
00:00 Topic Of The Day - TopN vs Others
00:34 Intro
00:42 BI-Lingual Analytics
01:01 What's Covered Today
01:40 TopN vs Others DAX - Year-To-Date
03:53 TopN vs Others DAX - Previous Year-To-Date
04:40 DataViz Problem - Shared X-axis
05:31 Data Validation - Selected Products
07:28 Data Validation - Others DAX Measure Rank
08:48 Next Steps - Data Visualization
09:25 Inspiration for DataViz
09:47 DataViz Problem - Reminder
10:16 Final DataViz Product
10:46 Painpoints With Copy-pasting
11:20 Summary
11:34 Feedback? Comment?
11:41 Visit Links
11:57 End
▼▼▼▼▼▼▼▼▼
Make sure to hit the 👍 button and ❗❗ SUBSCRIBE ❗❗ to my channel.
If you have any questions, just let me know either in the comments down below 👇 or send us an e-mail 📩.
▲▲▲▲▲▲▲▲▲
🤝 HOW TO CONNECT 🤝
LinkedIn - / bilingualanalytics
Twitter - / bilanalytics
Subscribe - / @bilingualanalytics
ABOUT ME: https://bilingualanalytics.com.au/abo...
📍 – Sydney, Australia
📽 GEAR:
📷 – Sony ZV-E10
🎙 – AT2020
🔦 – Neewer 18” Ring Light, Elgato Key Light
🎧 – BOSE QC35
🖥 – Dell Curved 34"
💻 – Macbook Pro M3 Max
#PowerBI #DataVisualization #Reporting