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!

[PBIdashboards]

The Matrix approach in the accepted answer is correct  put Month in Columns well, your categories in Rows, and values in Values. This is the standard way to "transpose" a table visual in Power BI without touching the data model.

One limitation to be aware of: once published, users in Power BI Service can filter by month but can't add or remove month columns themselves without the developer going back to Desktop.

If your Finance users need to switch which months appear in columns themselves (e.g., show last 3 months vs last 6 months vs YTD) in the published report, Flexa Tables on AppSource handles this  dynamic column selection without republishing

[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.