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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
the_glaze_tail
New Member

Can I unpivot this column in Power BI?

I'm new to Power BI an I'm working with the November Zendesk Content Package for Power BI.  It includes a 'Ticket_Metrics' table with automatically calculated columns.

 

I've specifically isolated one of those columns below, selected the 11th row, and you can see two numbers next to calendar and business, respectively.

 

  • Is this "Record "field containing two values some kind of Power Pivot output?
  • How do I pull these two seperate numbers out and put them intot their own column?

I've tried to "Unpivot Columns" but it doesn't seperate the numerical values.

 

zendesk_reply_time.png

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@the_glaze_tail

 

Try to clicking to Expand Columns, icon on the right of reply_time_in_minutes column




Lima - Peru

View solution in original post

2 REPLIES 2
Vvelarde
Community Champion
Community Champion

@the_glaze_tail

 

Try to clicking to Expand Columns, icon on the right of reply_time_in_minutes column




Lima - Peru

Of course it was right in front of me! Thank you! 🙂

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.