Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Reply
SIBI1998
Helper I
Helper I

Transform Data with Group

Hi Connections,

 

           I had  Stuck with here like I had group some Column Named branch but it wont shoe it on Transform Data plz help me out and I want to Create an Relation with the Branch.

 

 

SIBI1998_0-1654583707650.png

 

 

SIBI1998_1-1654583952722.png

 

 

1 REPLY 1
v-jingzhang
Community Support
Community Support

Hi @SIBI1998

 

The "BRANCH" column is a grouping column created in the data model. It's similar to a calculated column created with DAX, which is not able to appear in Power Query Editor. This is by design. 

 

Additionally, if you want to create a relationship between tables, you can switch to Model view and create relationships there. 

vjingzhang_0-1654832613983.png

 

If you want to have a grouping column in Power Query Editor, you can create a custom column or a conditional column based on other columns directly in Power Query Editor. 

Add a conditional column 

Add a custom column 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.