What is a Display Folder in Power BI?
If your Power BI data model has grown into a long, confusing list of columns and measures, you're not alone. Finding the right field can feel like searching for a needle in a haystack. This is where Display Folders come in, providing a simple yet powerful way to bring order to your model. This article will show you exactly what Display Folders are and how to use them to make your reports cleaner and easier to navigate for everyone involved.
What Exactly is a Display Folder in Power BI?
A Display Folder is a virtual folder used to group and organize measures and columns within the Fields pane in Power BI. Think of it like creating folders on your computer's desktop to group related files. These folders don't change your actual data, the underlying table structure, or your DAX calculations, they only change how your fields are displayed to you and other report users.
Their sole purpose is to improve the user experience. Instead of forcing users to scroll through a flat, alphabetically sorted list of dozens or even hundreds of fields, you can group them logically. For example, you can create a "Sales Metrics" folder for all your sales-related measures like Total Sales, YTD Sales, and Avg. Order Value, or a "Customer Details" folder for columns like Customer Name, City, and Segment.
This organizational layer makes your data model intuitive and far less intimidating, helping users find what they need in seconds instead of minutes.
Why You Should Tame Your Data Model with Display Folders
At first, organizing fields into folders might seem like a "nice-to-have" cosmetic change. But as your data models grow in complexity, it becomes an absolute necessity. Adopting this practice delivers several key benefits.
Significantly Reduces Clutter
The most immediate benefit is a cleaner, more organized Fields pane. When you have a table with 50+ columns and 20+ measures, the list becomes overwhelming. Grouping these fields tidies up the workspace, making it look professional and manageable. It's the difference between a desk with neatly labeled file folders and one covered in a random pile of papers.
- Before: A long, intimidating list of
Sales Amount,Sales Target,Sales YTD,Shipping Cost,Shipping Date,Region,Country, etc. - After: A clean structure with folders like
Sales Measures,Shipping Details, andGeography.
Improves the User Experience for Everyone
Whether you're the sole report author or building a model for a team of analysts, a well-organized model is a gift. Teammates who are less familiar with the model can easily discover relevant fields by browsing through logical folders. This reduces training time, minimizes questions, and empowers more people to build their own reports confidently without needing to memorize every field name.
Helps Standardize Your Data Models
By creating a consistent folder structure across all your reports, you establish a standard that your entire organization can follow. When a user opens a new Power BI report, they'll already know where to look for marketing KPIs, financial measures, or product attributes because it follows the same pattern they're used to. This standardization is crucial for creating a scalable and efficient business intelligence environment.
How to Create Your First Display Folder: A Step-by-Step Guide
Creating display folders is done in the Model View of Power BI Desktop. The process is straightforward once you know where to look. Let's walk through it together.
For this example, imagine we have a Sales table with several measures we want to organize: Total Revenue, Total Units Sold, % Profit Margin, and Average Transaction Value.
Instead of seeing them scattered in the Fields pane, we want to group them into a folder called "Key Sales Metrics".
Step 1: Navigate to the Model View
First, open your Power BI Desktop file. On the left-hand side of the window, you'll see three icons for Report View, Data View, and Model View. Click on the Model View icon (it's the one that looks like a diagram of tables).
Step 2: Select the Fields You Want to Group
In the Fields pane on the right-hand side, find the table containing the fields you want to organize. Click on the first measure (e.g., Total Revenue), then hold down the Ctrl key and click on the other measures you want to include (Total Units Sold, % Profit Margin, Average Transaction Value).
With all desired fields selected, look at the Properties pane, which is typically located below the Fields pane.
Step 3: Define the Display Folder Name
Within the Properties pane, scroll down until you find the input box labeled Display folder. It's usually under the "General" section.
Click inside the box and type the name for your folder. In our case, type in Key Sales Metrics.
Press Enter. Power BI will immediately apply the change.
Step 4: Verify Your New Folder in the Report View
Now, switch back to the main Report View by clicking the top icon on the left. Look at your Sales table in the Fields pane. You will now see that the measures you selected are no longer in the main list. Instead, there's a new folder icon labeled "Key Sales Metrics." You can click the arrow to expand or collapse it, revealing your neatly organized measures.
Congratulations! You've just created your first Display Folder.
Going Deeper: Creating Nested Folders (Subfolders)
You can add another layer of organization by creating subfolders. This is particularly useful in very complex models. For example, within a general "Marketing" folder, you might want subfolders for "SEO Metrics," "Paid Ads," and "Email Campaigns."
Creating a subfolder is as simple as using a backslash \ character in the Display Folder name.
Let's say we have three SEO measures: Organic Sessions, Avg. Ranking, and Click-Through Rate. We want to put them in an "SEO" subfolder inside a main "Marketing Metrics" folder. Here's how:
- Navigate to the Model View.
- Select the
Organic Sessions,Avg. Ranking, andClick-Through Ratemeasures. - In the Properties pane, find the Display folder field.
- Type
Marketing Metrics\SEOin the box. - Press Enter.
When you switch back to the Report View, you'll see a primary folder called "Marketing Metrics." When you expand it, you'll find your "SEO" subfolder right inside. It’s an easy-to-use and intuitive way to structure information hierarchically.
Best Practices for Organizing Your Power BI Model
Now that you know how to create folders, it's just as important to know how to use them effectively. A bad folder structure can be just as confusing as no structure at all. Here are some best practices to follow.
1. Maintain Consistent Naming Conventions
Decide on a naming standard and stick to it. Will your folder names be singular ("Metric") or plural ("Metrics")? Will they be in Title Case ("Sales Metrics") or lowercase ("sales metrics")? Consistency makes your model predictable and professional.
2. Create a Dedicated Folder for Measures
Measures are fundamentally different from columns, so separate them. A common practice is to create a top-level folder for all measures. To ensure this folder always appears at the top of the table list, you can prefix the folder name with an underscore or a symbol, like _Measures or ! Key Metrics. Since the Fields pane sorts alphabetically, this trick keeps your most important calculations visible and accessible.
3. Group Logically by Business Function
Organize your folders in a way that reflects how your business operates. Create high-level folders for core functional areas like Finance, Sales, Marketing, and Inventory. This structure is intuitive for users from those departments because it mirrors their mental model of the company.
4. Don't Go Overboard with Subfolders
While subfolders are great, having too many nested levels can be counterproductive. If a user has to click through five folders to find one metric, the system becomes cumbersome. Aim for a structure that is two or, at most, three levels deep. If you need more depth, it might be a sign that your table is trying to do too much and should be split into smaller, more focused tables.
5. Plan Your Structure Before Building
For a new or complex model, take a couple of minutes to sketch out your ideal folder structure on a whiteboard or a piece of paper. This forethought saves a lot of time re-organizing fields later. Think about the primary user groups and design a structure that makes the most sense for them.
Final Thoughts
Display folders are an essential Power BI feature for anyone serious about building clean, scalable, and user-friendly data models. By taking a few minutes to group your measures and columns into logical folders, you transform a potentially chaotic list of fields into an intuitive, well-organized analytics tool that colleagues and stakeholders will actually want to use.
This level of manual setup and organization, while powerful, highlights the learning curve involved in traditional BI tools. At Graphed, we aim to eliminate this friction entirely. We built a platform where you can connect your data sources in seconds and ask questions in plain English to instantly generate real-time reports and dashboards. Instead of spending time in model views organizing hundreds of fields, you can simply describe what you want to see - like “create a dashboard comparing our ad spend vs. revenue by campaign” - and have it built for you automatically.
Related Articles
What SEO Tools Work with Google Analytics?
Discover which SEO tools integrate seamlessly with Google Analytics to provide a comprehensive view of your site's performance. Optimize your SEO strategy now!
Looker Studio vs Metabase: Which BI Tool Actually Fits Your Team?
Looker Studio and Metabase both help you turn raw data into dashboards, but they take completely different approaches. This guide breaks down where each tool fits, what they are good at, and which one matches your actual workflow.
How to Create a Photo Album in Meta Business Suite
How to create a photo album in Meta Business Suite — step-by-step guide to organizing Facebook and Instagram photos into albums for your business page.