cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## Pivoting Data in a Matrix

I want to be able to pivot how data looks in a matrix. I have the following table currently existing:

 Item A B A B Hour 9 9 10 10 Day Mon xyz xyz xyz xyz Tue xyz xyz xyz xyz Wed xyz xyz xyz xyz

I want to be able to pivot the table so that my values are showing as following:

 Hour 9 10 11 12 Mon A Mon B Tue A Tue B

Essentially the table will show the day of the week twice so that I can easily compare.

The values/fields I have are:
1. Day of the Week

2. Hour

3. Value A

4. Value B

1 ACCEPTED SOLUTION
Community Support

Hi  @andrewb95 ,

I created some data:

Here are the steps you can follow：

1. Enter the power query, select ValueA and ValueB two columns, click Transform-Unpivot Columns

Result:

2. Create calculated column.

``Day_of_the_week = 'Table'[Day of the week] &""& 'Table'[Value]``

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

2 REPLIES 2
Community Support

Hi  @andrewb95 ,

I created some data:

Here are the steps you can follow：

1. Enter the power query, select ValueA and ValueB two columns, click Transform-Unpivot Columns

Result:

2. Create calculated column.

``Day_of_the_week = 'Table'[Day of the week] &""& 'Table'[Value]``

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Super User

Not sure if it 100% meets you requirement but in the Values section of the matrix Format pane there is a setting called "Show On Rows". Try enabling it.

Ben Dobbs

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.