Forum Discussion
Daryn-TP
4 years agoRegular Visitor
How do I group a matrix by Values?
I have a table similar to the following table built in PBI. There are 4 metrics and they are compared accross 3 dates. however I want to group it like so (which i put together in excel). How d...
- 4 years ago
If you unpivot the value columns in the query editor, then you can use the resulting attribute column for your column headers.
Getting the formatting how you want it is a separate challenge.
AlexisOlson
4 years agoSuper User
If you unpivot the value columns in the query editor, then you can use the resulting attribute column for your column headers.
Getting the formatting how you want it is a separate challenge.
Daryn-TP
4 years agoRegular Visitor
So I tried the solution you suggested however only one of the attributes is showing up. Any idea what I can do to make all the attributes show up?