cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

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

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: Horizontal Sorting of tables

Hi @Shruti_Goyal94,

 

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.

 1.PNG

 

"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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
deepak91g Regular Visitor
Regular Visitor

Re: Horizontal Sorting of tables

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

 

tablesorter.png

3 REPLIES 3
Community Support Team
Community Support Team

Re: Horizontal Sorting of tables

Hi @Shruti_Goyal94,

 

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.

 1.PNG

 

"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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Horizontal Sorting of tables

@v-yulgu-msft

 

Thank you so much for your help. I wil ltry indexing the columns and change the order. 

 

Cheers

Shruti

deepak91g Regular Visitor
Regular Visitor

Re: Horizontal Sorting of tables

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

 

tablesorter.png