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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors