Forum Discussion
Create columns group
Is it possible to create custom groups or categories of fields in Power BI that are independent of the underlying tables?
For example, I would like to create a category called Product_Datas that contains:
- Some columns from the Product table
- Some columns from the Date table
- Some columns from the Customer table
- Some measures from the Measures folder
Ideally, I would like to organize these fields into a single logical group without modifying the data model, relationships, or overall star schema design.
The objective is to replicate the user experience and field organization available in another BI tool as part of a migration project to Power BI, while still preserving Power BI modeling best practices and the existing semantic model structure.
Has anyone implemented a similar approach, or is there a recommended way to achieve this in Power BI?
Hi,
Power BI doesn't currently support creating custom field groups/folders that span multiple tables in the Fields pane. Display folders are limited to organizing fields within the same table, and measures can only be organized into display folders within their own table.
If your goal is to provide a more business-friendly experience without changing the star schema, here are a few options:
- Display Folders: Organize columns and measures within each table. This helps reduce clutter but cannot group fields from different tables.
- Perspectives (available with Analysis Services/Power BI semantic models via tools like Tabular Editor): Create a curated view of the model by exposing only the fields relevant to a particular audience. While perspectives don't create cross-table folders, they significantly simplify the field list for report authors.
- Field Parameters: Useful for allowing users to dynamically switch between fields in visuals, but they don't reorganize the Fields pane.
- Dedicated Measures Table: Store all measures in a single table and use display folders to categorize them. This is a common best practice, although it only applies to measures.
Unfortunately, there isn't a native feature that allows you to create a logical folder such as Product_Datas containing columns from Product, Date, Customer, and measures while leaving those fields in their original tables.
If you're migrating from another BI tool that supports virtual field groupings, the closest Power BI equivalent is typically a combination of Perspectives for a simplified model and Display Folders for organization.
Hope this helps!
Thanks!
4 Replies
Hi PBI_2K26 - Power BI doesn't currently support creating a custom field group that is completely independent of the underlying tables.
If this capability is important for your migration scenario, I'd encourage you to submit it as an idea on the Microsoft Fabric Ideas portal. If others find it valuable, they can vote for it, which helps increase its visibility with the product team.
Fabric Ideas - Microsoft Fabric Community
Hope this helps.
Hi PBI_2K26
We would like to inquire whether have you got the chance to check the solutions provided by rajendraongole1 in commiunity to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.
Thank you.Hi,
Power BI doesn't currently support creating custom field groups/folders that span multiple tables in the Fields pane. Display folders are limited to organizing fields within the same table, and measures can only be organized into display folders within their own table.
If your goal is to provide a more business-friendly experience without changing the star schema, here are a few options:
- Display Folders: Organize columns and measures within each table. This helps reduce clutter but cannot group fields from different tables.
- Perspectives (available with Analysis Services/Power BI semantic models via tools like Tabular Editor): Create a curated view of the model by exposing only the fields relevant to a particular audience. While perspectives don't create cross-table folders, they significantly simplify the field list for report authors.
- Field Parameters: Useful for allowing users to dynamically switch between fields in visuals, but they don't reorganize the Fields pane.
- Dedicated Measures Table: Store all measures in a single table and use display folders to categorize them. This is a common best practice, although it only applies to measures.
Unfortunately, there isn't a native feature that allows you to create a logical folder such as Product_Datas containing columns from Product, Date, Customer, and measures while leaving those fields in their original tables.
If you're migrating from another BI tool that supports virtual field groupings, the closest Power BI equivalent is typically a combination of Perspectives for a simplified model and Display Folders for organization.
Hope this helps!
Thanks!
Hi PBI_2K26
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Thank you.
