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.
Mitchell Pearson from Pragmatic Works is back with another insightful tutorial, this time focusing on a powerful feature in Power BI—Field Parameters. In this video, he demonstrates how Field Parameters can be used to give users the flexibility to choose and visualize specific measures in a single chart. This feature is a game-changer for creating clear and concise reports without overwhelming end-users.
1. Naming and Selection: Mitchell names the parameter, e.g., "Base Measures + Prior Year," and selects the measures in the desired order. (The order determines how they appear in the slicer.)
2. Adding the Slicer: Mitchell adds the slicer to the report page, saving a step by directly choosing the option to add a slicer during the parameter creation process.
3. Connecting the Slicer to the Visualization: Initially, the slicer doesn't affect the chart. Mitchell removes the measures from the chart and connects the new parameter table's column (containing measure names) to the Y-axis of the chart.
4. Dynamic Visualizations: The slicer now dynamically influences the chart based on the user's selections, allowing for seamless visualization changes.
Mitchell wraps up the video by inviting viewers to subscribe to the Pragmatic Works' YouTube channel for similar content. Viewers that want even more courses are invited to join the Pragmatic Works' on-demand learning platform, which offers courses in Power BI, Power Automate, Azure, and many other Microsoft applications.
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.