Forum Discussion
How To Handle this in a Matrix
For interested people, this is how I solved it ...
I created a Table holding my 'Report Classes'.
I had my basic values stored in a fact table by report class, and uploaded into PowerBI.
Finally just could cretae a Matrix with 2 Measures on that fact. Works Fine, had to use the Sort By Column to Avoid Alpha sorting (was still on during the screenshot) ....Table in SQLTables in PBIMatrix
Hi Anonymous,
Generally, in a Matrix visualization, fileds dragged into columns represent column group and fields dragged into rows represent row group. It is not allowed to add a measure into row cell, because measure returns result which will be regarded as detailed values displayed in matrix.
So, I'm afraid your requirement cannot be achieved directly. Would you please share some sample data, including data view and sample measures so that I can test whether there existing any workaround for you?
Best regards,
Yuliana Gu
For interested people, this is how I solved it ...
I created a Table holding my 'Report Classes'.
I had my basic values stored in a fact table by report class, and uploaded into PowerBI.
Finally just could cretae a Matrix with 2 Measures on that fact. Works Fine, had to use the Sort By Column to Avoid Alpha sorting (was still on during the screenshot) ....Table in SQLTables in PBIMatrix