Forum Discussion
Split a matrix table by value label
Hello all,
I have a matrix table comparing product categories and the year they were sold. Year is column, category is row.
My values are total units sold as a # and another showing that percent that # is of the grand total for each category.
By default, it's showing the # and % as a sub column under the year column. However I want to arrange it so all # are together on one side and all % is on the other. Screenshot example attached.
The # are straight out of my database and the % is a calculated measure if that makes a difference.
Thoughts?
Hi mjohnsonsmi,
don't know how you have your model setup and if this two values are measures or columns.
If they are column one option is to unpivot them and then use the attribute column to make the split.
Another way is to follow this link that make use of measures to have it on the rows, however you can adapt it and use it for puting value in columns of the matrix.
As you can see below you ave the same result.
In attach find PBIX file, UNPIVOT is a single table for the first image, the other two MEASURE_COLUMNS are used for the second result.
Two ways same result, hope it helps you get some ideas of how to fix your issue.
Regards,
MFelix
2 Replies
Hi mjohnsonsmi,
don't know how you have your model setup and if this two values are measures or columns.
If they are column one option is to unpivot them and then use the attribute column to make the split.
Another way is to follow this link that make use of measures to have it on the rows, however you can adapt it and use it for puting value in columns of the matrix.
As you can see below you ave the same result.
In attach find PBIX file, UNPIVOT is a single table for the first image, the other two MEASURE_COLUMNS are used for the second result.
Two ways same result, hope it helps you get some ideas of how to fix your issue.
Regards,
MFelix
Hello Felix,
That did it! A bizzare workaround if ever I saw one but I can't argue with results. I ended up doing using the first method you described. Thank you!
