How to Create a Measure Folder in Power BI

A Power BI report with just a few measures is clean and manageable. But as your analysis grows and you add calculations for sales, marketing, and operations, the Fields pane can quickly become a long, disorganized list that’s impossible to navigate. This article will show you exactly how to organize your calculations into measure folders, transforming your messy list into a clean, intuitive structure that’s easy for anyone to use.

Why Should You Organize Your Power BI Measures?

Taking a few minutes to organize your measures isn't just about making things look tidy, it's about making your report more functional, maintainable, and user-friendly. When you have dozens or even hundreds of measures scattered across different tables, finding the exact calculation you need feels like searching for a needle in a haystack.

A well-organized model offers several huge advantages:

• Improved Navigation: When measures are grouped logically (e.g., "Sales," "Marketing ROI," "Inventory"), you and your users can find what you need in seconds instead of scrolling through an endless alphabetical list.
• Better User Experience: For colleagues who use your report but don't build it, a clean folder structure makes self-service analysis possible. They can easily find the metric they’re curious about without needing to ask you where to look.
• Simpler Maintenance: Need to update all of your time-intelligence calculations? No problem. Go to the "Time Intelligence" folder. When bugs or issues arise, it’s much faster to troubleshoot when related measures are grouped together.
• Scalability: A small report can get by without folders, but as you add more data sources and complexity, a disciplined structure is the only thing that keeps the model from becoming unusable. Starting with good habits pays off every time.

The Two Main Ways to Create Measure Folders

There are two primary methods for grouping measures in Power BI. Understanding both is helpful, as you might see the older method in existing reports.

1. The "Measure Table" Method: This is the classic approach. You create a new, empty table that serves as a dedicated container for your measures. This physically separates your calculations into their own "table" in the Fields pane.
2. The "Display Folder" Method: This is the modern, built-in, and more flexible way. You assign a "Display Folder" property to a measure, which groups it visually in a folder within its existing home table, without actually moving it. This allows for powerful nested organization.

While the Measure Table method works, the Display Folder approach is now the recommended best practice, offering more power and flexibility. Let's walk through how to implement both.

Method 1: Creating a Dedicated Measure Table (The Classic Way)

This was the go-to method for years before Display Folders were introduced. It provides a very clean separation, placing all your key calculations in one dedicated spot at the top of your Fields list.

Step 1: Create a New Blank Table

First, we need to create an empty table that will act as our folder.

• In the Home ribbon of Power BI Desktop, click on Enter Data.
• A "Create Table" window will pop up. You don't need to put any data in it. Simply name the table.
• It's a common best practice to name measure tables with a leading space or underscore, like _Measures_ or Key Metrics. This ensures the table sorts to the top of the Fields pane, making it easy to find.
• Click Load. Your new, empty table will now appear in the Fields pane.

Step 2: Move Your Measures to the New Table

Now, we need to re-home our existing measures into our new container table.

• Find a measure you want to move in the Fields pane and click on it to select it.
• With the measure selected, the Measure tools contextual tab will appear in the top ribbon.
• In the "Properties" section of the ribbon, you'll see a dropdown menu for Home table. Click it and select your newly created measure table (e.g., "_Measures").
• The measure will disappear from its original table and reappear under your new measure table.

You’ll have to repeat this process for every measure you want to move. This is the main drawback of this method - it can be tedious for reports with many measures.

Step 3: Hide the Empty Column to Finalize the Folder

If you expand your new measure table, you'll see your measures plus an extra item called Column1. This was created automatically when you made the blank table. Leaving it visible makes the table behave like a regular data table, which isn't what we want.

• In the Fields pane, find Column1 under your new measure table.
• Right-click on Column1 and select Hide.
• As soon as you hide it, you'll notice the table's icon changes from a grid to a calculator icon. This is Power BI's visual signal that this table now exclusively holds measures, completing the transformation into a true "measure folder."

Method 2: Using Display Folders (The Modern & Recommended Approach)

The Display Folder method is quicker, more powerful, and allows for creating sub-folders for even better organization. Instead of moving measures, you are simply telling Power BI where to display them. This is all done from the Model View.

Step 1: Switch to the Model View

On the left-hand side of Power BI Desktop, click the icon for the Model view. This is where you see the relationships between your tables. It's also the most efficient place to manage properties for multiple columns and measures at once.

Step 2: Assign a Display Folder to a Single Measure

Let’s start by organizing one measure.

• In the Fields pane on the right, find and click on the measure you want to place in a folder.
• With the measure selected, look at the Properties pane (if it's not visible, go to the "View" ribbon and check the box for "Properties").
• Scroll down in the Properties pane until you find the input box labeled Display folder.
• Simply type the name of the folder you want to create, like Sales, and press Enter.

Instantly, if you look back at your Fields list, you'll see that a "Sales" folder has appeared in that measure's home table, with your measure neatly tucked inside. You didn’t have to move anything - you just assigned a label.

Step 3: Organize Multiple Measures at Once (The Big Time-Saver)

Here’s where this method truly shines. You don’t have to organize measures one by one. You can do them in bulk.

• In the Model View's Fields pane, select the first measure you want to organize.
• Hold down the Ctrl key and click on all the other measures you want to group together into the same folder (e.g., Total Revenue, Avg Order Value, Total Orders).
• With all of them selected, go to the Properties pane. The Display folder input box will be waiting.
• Type the folder name, like Sales, and press Enter.

Every single measure you selected will instantly be moved into the "Sales" folder. You can organize dozens of measures in just a few seconds.

Step 4: Create Nested Sub-Folders for Advanced Organization

Need even more structure? Display Folders support nesting, which is incredibly useful for complex models. To create a sub-folder, you just use a backslash (\) in the folder name.

For example, let's say you have several time-intelligence measures within your sales data:

• Select your time-intelligence measures (e.g., Sales MTD, Sales QTD, Sales YTD).
• In the Display folder box, type: Sales\Time Intelligence.
• Press Enter.

Power BI will automatically create a "Sales" folder, and inside of it, a "Time Intelligence" sub-folder containing your selected measures. You can go multiple levels deep (e.g., Finance\P&L\Expenses) to create a perfectly logical hierarchy that matches your business structure.

Best Practices for Naming and Structuring Your Folders

Simply creating folders isn't enough. A good strategy will make your report a joy to use.

• Use Consistent Naming: Stick to a clear and predictable naming convention. Group by business function (Sales, Marketing, Finance, Operations) or by metric type (Ratios, Time Intelligence, Growth Metrics). Don't mix styles.
• Keep It Simple: While you can create deep sub-folders, don’t overdo it. A structure that is three or four levels deep can become just as confusing as no structure at all. Aim for clarity, not complexity.
• Separate Core vs. Derived Measures: Some analysts like to create a top-level folder for "Core Measures" (like [Total Sales] or [Total Cost]) and separate folders for calculations that build on them (like [Profit Margin] or [YoY Growth]).
• Create a "Work In Progress" Folder: Have new measures you are testing? Create a WIP or Sandbox display folder. This keeps incomplete or unverified calculations from cluttering up your final, clean folder structure. Once they’re ready, you can easily move them to their permanent home.

Final Thoughts

Organizing your Power BI measures into folders is a small investment of time that delivers a huge return. By moving from a flat, messy list to a clean, hierarchical structure, you make your reports more professional, easier to maintain, and far more intuitive for your end users to navigate. The Display Folder method, in particular, is a fast and flexible way to create and manage this structure at scale.

Of course, manually building these analytical models, organizing the report structure, and writing DAX from scratch still takes time away from acting on insights. Instead of spending hours in the weeds of report creation, we designed Graphed to handle the heavy lifting for you. You can simply connect your data sources - like Google Analytics, Shopify, and Salesforce - and ask for what you need in plain English. Graphed automatically generates interactive, real-time dashboards for you, getting you from raw data to actionable insights in seconds.