How To Handle this in a Matrix

[Anonymous]

Hello,

I'm looking for a way to creata a Matrix that would like a bit like this.

In the Columns would be different Month/Dates/Hours.

Each line is a Measure, but how to create Rows ?

I could cretae the Measure for every time-slice but how can I pivot the (up to 50) measures into rows ?

[v-yulgu-msft]

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

[Anonymous · Accepted solution]

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