Need Help In matrix visual

[Abhijsrwala1]

Hi all,

How do I create below matrix ? the rows qty, sales,GP are different columns which are used as rows. 

[v-chenwuz-msft]

Hi @Abhijsrwala1 ,

To customize the creation of the matrix, you need to create two tables, one containing only the row names, one containing the column names, and one measure for switching the measure of the current row

Pbix file in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Abhijsrwala1  ,Check if "show on row" in Matrix Visual, can help. That will bring measures to row.

If you need a measure to dimension conversion. You can use calculation group

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0