How to Create Folders in Power BI Fields

Working with a large Power BI data model can quickly feel like trying to find a specific document on a messy desk. When you're faced with a seemingly endless list of tables and fields, building even a simple report can become a time-consuming scavenger hunt. This article will show you how to tidy up your data model using one of Power BI's most helpful and underused features: display folders.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Bother with Folders in the Fields Pane?

Before we jump into the "how," let's talk about the "why." If you've only worked with small datasets, you might not see the immediate need for folders. But as your models grow, the pain becomes real. A flat list of dozens - or even hundreds - of fields is inefficient and intimidating.

Here's what a cluttered Fields pane does to your workflow:

• Slows You Down: Constantly scrolling and searching for the right measure or column wastes valuable time that could be spent on actual analysis.
• Increases Errors: It's easy to drag the wrong field into a visual when similar-sounding names are scattered throughout a long list (e.g., 'SalesAmount' vs. 'TotalSales').
• Confuses Other Users: When you share your Power BI file or publish a dataset, a disorganized model is difficult for colleagues to navigate. They have to guess which fields are important measures and which are just structural columns.

Think of it like a kitchen. You wouldn't throw all your utensils, spices, and pots into one giant drawer. You organize them so you can quickly grab what you need. Folders in Power BI serve the exact same purpose, creating logical groups for your measures and columns so that building reports becomes a smooth, intuitive process.

Creating Folders in the Model View (The Classic Method)

The Model View in Power BI Desktop is the most common place to perform your data modeling tasks, including organizing fields into folders. This view shows you the relationships between your tables and gives you access to the Properties pane, which is what we need.

Follow these steps to create your first folder.

Step 1: Switch to the Model View

In Power BI Desktop, look at the left-hand side of the window. You'll see three icons: Report, Data, and Model. Click on the Model view icon. You should see a diagram of all the tables in your data model and the relationships connecting them.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step 2: Select the Fields to Group

On the right-hand side of the screen, you'll see the Data pane, which lists all your tables and fields. Find the table you want to organize. Now, select the fields you want to place inside a folder.

You can select multiple fields at once by holding down the Ctrl key while you click on each field. For a consecutive list of fields, click the first one, hold down the Shift key, and click the last one.

Example: Let's say we have customer-related fields like 'Customer Name', 'Customer Email', 'City', 'State', and 'Country' all in our Customers table. We would hold Ctrl and click on each of these fields to select them all.

Step 3: Find the "Display folder" Property

With your fields selected, look at the Properties pane (if you don't see it, go to the View tab in the ribbon and make sure the "Properties" checkbox is ticked). Scroll down within the Properties pane until you find the text box labeled Display folder.

This is where the magic happens. Whatever you type into this box will become the name of the folder those selected fields live in.

Step 4: Name Your Folder and Press Enter

Click inside the "Display folder" box and type in a logical name for your group of fields. Good names are descriptive and intuitive. For our customer example, we might name the folder "Customer Demographics" or "Customer Location".

After typing the name, simply press Enter.

Instantly, you will see the change happen in the Data pane. The fields you selected are no longer cluttering the root level of your table. Instead, they are neatly tucked away inside a new folder with the name you just provided, marked with a small folder icon.

That's it! You've successfully decluttered a part of your data model.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

A Quick Shortcut: Creating Folders Directly in the Report View

While the Model View is powerful, you don't always want to switch screens just to create a folder. Luckily, there's a lesser-known but much faster way to do it directly from the Report or Data view's Fields pane.

This method is great when an idea for a folder strikes you right in the middle of building a chart. You can organize on the fly without breaking your flow.

1. Stay in the Report View or Data View.
2. In the Data pane on the right, find the table you want to work with.
3. Use Ctrl + click to select multiple measures or columns you want to group together.
4. Here's the trick: After selecting them, just drag one of the selected fields onto another of the selected fields and drop it. Power BI will understand that you are trying to create a group.
5. A dialog box will appear, prompting you to "Create a new folder". Type the name you want for the folder in the "Folder name" field.
6. Click "Create" and your new folder will appear immediately in the Data pane with the selected fields inside.

This drag-and-drop method is incredibly efficient for quick organizational tasks while you're focused on building visualizations.

Advanced Tips and Best Practices

Creating a single folder is just the beginning. To truly become a Power BI organization pro, you'll want to use these advanced techniques.

Creating Subfolders (Nested Folders)

Sometimes one level of folders isn't enough. You might have sales metrics, but want to group them further into "Total Sales" and "Average Sales." You can easily create folders within folders (subfolders) using a backslash ().

When you are in the Display folder property box (in the Model view), simply separate the parent folder and child folder name with a backslash.

For example:

• Financials\Revenue would create a parent folder called "Financials" with a subfolder inside it called "Revenue".
• Financials\Costs would put another subfolder under "Financials" called "Costs".

This allows you to create a deeply layered and logical structure for very complex models.

Organizing Your Measures Separately

One of the most valuable organizational habits is to separate your measures (the calculations you create with DAX) from your regular columns. This makes your key calculations stand out and prevents users from pulling in a raw, un-aggregated column by mistake.

A common convention is to create a dedicated "measure folder" and place it at the top of the field list for easy access. You can force the folder to the top by starting its name with an underscore or a number.

For example, you could name your measure folder _Measures or 1. Key Metrics. All the central calculations for your report - like [Total Sales], [Profit Margin %], and [YoY Sales Growth] - would live together in this folder.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Moving and Removing Fields

What if you want to add a field to a folder you created earlier, or pull one out? It's straightforward:

• To add a field: Select the field, go to the "Display folder" property, and type in the exact name of the existing folder. The field will move into it.
• To remove a field: Select the field(s), go to the "Display folder" property, and simply delete the text in the box and press Enter. The fields will return to the top level of the table.

A Quick Note on Deleting Folders

You may have noticed that you can't right-click and "delete" a folder. That's because a folder isn't an object itself, it's just a display property of the fields inside it. A folder automatically disappears when the last field is removed from it.

Final Thoughts

Bringing order to your Power BI Fields pane with folders is a small effort that pays huge dividends. It transforms a chaotic list of data points into a clean, intuitive structure that makes building reports faster and less error-prone for you and your entire team.

Manually organizing data models in complex tools like Power BI is one way to tackle data complexity. At Graphed, we're focused on eliminating that type of tedious work altogether. We realized that for most marketing and sales teams, the real bottleneck isn't knowing which folders to create, but the hours spent logging into countless platforms and stitching data together just to get an answer. We built Graphed so you can simply connect your data sources - like Google Analytics, Shopify, and Facebook Ads - and then ask for what you need in plain English. Instead of learning Power BI's interface, you just describe the dashboard you want to see, and our AI builds it in seconds.