Forum Discussion
pucities
6 years agoFrequent Visitor
How to pivot multiple columns into Matrix..
My data source looks something like this: StudentID Test1Score Test1Avg Test2Score Test2Avg Test3Score Test3Avg 1 75 75 86 80 87 68 2 60 75 96 80 69 68 3 74 75 74 8...
- 6 years ago
I think the better option is to unpivot data
https://radacad.com/pivot-and-unpivot-with-power-bi
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin - 6 years ago
v-lili6-msft
Community Support
6 years ago