Forum Discussion

SJHALANI's avatar
SJHALANI
Helper I
3 years ago
Solved

Transpose data in table visual

 Hi Guys! I have created a Table visual in Power Bi and it looks like this: However, I need this to be transposed. So that it looks something like this - basically months would be in column...
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, SJHALANI 

     

    You can try the following methods.

    In the Power Query-Unpivot Other Columns:

    Then use the matrix view.

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, SJHALANI 

 

You can try the following methods.

In the Power Query-Unpivot Other Columns:

Then use the matrix view.

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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