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.

    Transpose data in table visual.pbix44 KB
PBIdashboards's avatar
PBIdashboards
Post Patron
1 month ago

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