Forum Discussion
How to transpose a table visual
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.
6 Replies
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?
pls see my video
Link not found
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
Unbelievable.
I have been using powerbi for 2 years and I had never used this option.Thanks.
