Sign-up now and get instant access
Leave a comment
Customized training to master new skills and grow your business.
Beginner to advanced classes taught by Microsoft MVPs and Authors.
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
Quick references for when you need a little guidance.
Summaries developed in conjunction with our Learn with the Nerds sessions.
Digital goodies - code samples, student files, and other must have files.
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Community Discord Server
Start here for technology questions to get answers from the community.
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
It's time to address your client's training needs.
Learn how to get into IT with free training and mentorship.
Discover the faces behind our success: Meet our dedicated team
How can we help? Connect with Our Team Today!
Find all the information you’re looking for. We’re happy to help.
Welcome back to another insightful video tutorial at Pragmatic Works! In this session, Mitchell Pearson shares valuable insights on enhancing Power BI visualizations by making small yet impactful tweaks using built-in features. As Microsoft consistently rolls out updates, it's easy to overlook the full potential of these tools. Mitchell recounts a recent experience where a customer's visualization wasn't quite hitting the mark, prompting him to explore the powerful concept of small multiples.
Mitchell begins by showcasing the finished product—a clustered column chart that puts a unique spin on visualizing sales data by country over multiple years. The key here is utilizing small multiples to present each country's performance in its own mini chart. This not only adds clarity but also offers a visually compelling representation.
Taking the visualization to the next level, Mitchell introduces a constant line representing a significant event (in this case, 'Co'). This line, placed strategically in the middle of the data range, becomes a visual marker for a crucial point in time.
In the pursuit of making the visualization even more insightful, Mitchell introduces benchmarks—static lines representing performance thresholds. In this example, he sets a benchmark at 2.5 million in sales.
To tie everything together, Mitchell briefly covers customizing the title and making minor adjustments for a polished finish.
In just a few minutes, Mitchell transforms a basic visualization into a powerful tool for data analysis. The use of small multiples, constant lines, and benchmarks adds layers of insight, making the visual representation not only clearer but also more actionable. This tutorial serves as a reminder to explore the richness of Power BI's built-in features regularly and leverage them to their full potential.
If you found this tutorial helpful, don't forget to subscribe to the Pragmatic Works' YouTube channel for more insightful content. You can now also sign up for the Pragmatic Works' on-demand learning platform, which offers a wide range of courses, including those related to Microsoft products like Power BI, Power Automate, and Azure.
ABOUT THE AUTHOR
Mitchell Pearson has been with Pragmatic Works for 10 years as a Data Platform Consultant and the Training Manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.