Forum Discussion
Horizontal Sorting of tables
Hi guys,
Is there any way we can sort pivot table horizontally similar to we have in Excel pivot tables? Where we can sort values based on columns instead of having columns in alphabetical order.
Cheers
Hi Anonymous,
The Pivot table you mentioned above is called Matrix visual in Power BI, right? Currently, it is not possible to sort matrix by column headers. We can see there are only two oprions: sort by row, sort by value.
"Where we can sort values based on columns instead of having columns in alphabetical order. " For this requirement, you can refer to Matrix Column Head Order
Best regards,
Yuliana Gu
There is custom visual called TablerSorter and its very helpful in such scenarios. or Visit this link for detailed information http://blog.pragmaticworks.com/power-bi-custom-visuals-table-sorter
3 Replies
v-yulgu-msftMicrosoft Employee
Hi Anonymous,
The Pivot table you mentioned above is called Matrix visual in Power BI, right? Currently, it is not possible to sort matrix by column headers. We can see there are only two oprions: sort by row, sort by value.
"Where we can sort values based on columns instead of having columns in alphabetical order. " For this requirement, you can refer to Matrix Column Head Order
Best regards,
Yuliana Gu
Thank you so much for your help. I wil ltry indexing the columns and change the order.
Cheers
Shruti
- deepak91g
Resolver II
There is custom visual called TablerSorter and its very helpful in such scenarios. or Visit this link for detailed information http://blog.pragmaticworks.com/power-bi-custom-visuals-table-sorter