How to display dimension in column and messuares in rows in Matrix?

[Erin001]

Hi,

This question has been there for quite a while, and it is easy to be done in excel and some other BI tools.

basically, power Bi allow me to dispaly:

Category   M1     M2     M3

 c1             m11   m21    m31

 c2             m12   m22    m32

what my clients want to see is:

Category   c1        c2

M1             m11    m12

M2             m21    m22

M3             m31    m32

so, is there any way to do it simply? I have very large datasets and many other charts so redesign the datasets' structure is not a good solution for my case.

Thanks!

[Vvelarde · Accepted solution]

@Erin001

I just made a way to solve this: (is in Spanish )