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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sd_kevin
Advocate II
Advocate II

Is it possible to grab a sub group title in the same column as item name and move to its own column?

HI, 

I was wondering if there is a way to grab the Sub Group titles and move them to its own column.  The use case is that we have reports that contain the sub-group and the item name in the same column.  The items are the same in each sub-group so it is difficult to distingish Item "A" from Sub Group 1 vs item "A" from Sub Group 2.  Please see images below.

 

 

Raw Data:

ITEMAMOUNT
Sub Group 1 
A10
B20
Sub Group 2 
A30
B40

 

Desired Result:

Sub GroupItemAmount
Sub Group 1A10
Sub Group 1B20
Sub Group 2A30
Sub Group 2B40

 

Thank you!

1 ACCEPTED SOLUTION
camargos88
Community Champion
Community Champion

Hi @sd_kevin ,

 

Check this file: Download PBIX 

 

Capture.PNG



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

2 REPLIES 2
camargos88
Community Champion
Community Champion

Hi @sd_kevin ,

 

Check this file: Download PBIX 

 

Capture.PNG



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Thank you so much Richardo!  That worked like a charm!

 

Warm regards,

 

Kevin

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors