Forum Discussion
Split a matrix table by value label
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
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!
