How to transpose a table visual

[fellipea_ao]

Hello!

I have a dataset with 6 mi rows and 40 columns, so I ll show just a sample with 100 rows and 9 columns.

Here the dataset and PBI file:

Key = (date+user)

Date

User

Status (just 4 status in sample but in original df are 10)

Qtd_Area1 = quantity of calls in this area (I showed just 5 columns, but in original df are 14)

In powerbi file I have 5 measures that calculate the average of qtd_area1,2,3,4,5.

In powerbi I did just a normal table like that:

But I want to transpose to a table/matrix like that:

Anyone knows how can I do this?

ps:
1. I can't transpose the dataset in powerquery because the dataset has 7mi rows x 40 columns and I have a lot of pages and visuals active now.
2. The  table visual is in a page that have 16 columns as slicer (16/40).

3. And I cant use measures in "Rows" of the matrix.

Thank you for your attention.

[fellipea_ao]

Unbelievable.
I have been using powerbi for 2 years and I had never used this option.

Thanks.

[Ahmedx · Accepted solution]

https://1drv.ms/v/s!AiUZ0Ws7G26RiwicTVyVGhbaMShC?e=VtK9hSMeasure to row.mp4

[gkbradshaw]

This looks like you might hav a solution to my problem as well, but I cannot see the video. Any chance this is on YouTube instead?

[Ahmedx]

pls see my video

https://1drv.ms/v/s!AiUZ0Ws7G26RiwicTVyVGhbaMShC?e=VtK9hS

[RMBK18]

Link not found

[fellipea_ao]

Hello! The video showed that steps that worked for me.
That was my table 

I changed the visual from table to matrix, after this a created a matrix with the same fields in that position.

After, I changed that option