Master How YOU Organize Measures and Columns! A Power BI Tutorial

Nick Lee, a Pragmatic Works Data Engineer, presents a tutorial on how to effectively organize measures and columns in Power BI reports. 

Introduction

Nick introduces the topic of organizing measures and columns in Power BI reports. He explains that this is a common issue that comes up during his virtual mentoring sessions, even though users don't specifically ask for help with it. He emphasizes the importance of organizing measures and columns to make reports easier to use, especially when handing them off to others.

Example Power BI Report

Nick demonstrates an example Power BI report in Power BI Desktop. He shows the set of tables on the right side, including Customer, Date, Geography, Internet Sales, Product, Sales Territory, and Temperature. He opens the Internet Sales table to show the various columns and measures stored throughout.

Method 1: Measures Repository

Nick explains the first method of organizing measures using a measures repository. He describes how to create a table or repository to store measures in the data pane. He demonstrates how to select existing measures and move them to the measures repository. He also shows how to delete unnecessary columns and how the measures repository is recognized by Power BI.

Method 2: Display Folders and Subfolders

Nick introduces the second method of organizing measures using display folders and subfolders. He explains how to create folders and subfolders within tables and measures repositories. He demonstrates how to manually type in folder names and how to create nested folders. He also shows how to organize columns using display folders.

Conclusion

Nick wraps up the tutorial by summarizing the two methods of organizing measures and columns in Power BI. He emphasizes the importance of making reports easier to use and how these organizational techniques can benefit business users.

Need help with Power BI? With virtual mentoring from Pragmatic Works you can book time on Nick's calendar to get his help.

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Power BI and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.