Transpose data in table visual

[SJHALANI]

 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 columns, and other 2 columns should be in row

I am not sure how to do this. Any help would be relaly appreciated, Thanks!

[Ashish_Mathur]

Hi,

Switch to a matrix visual.

[v-zhangti · Accepted solution]

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.