Horizontal Sorting of tables

[Anonymous]

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

[v-yulgu-msft · Accepted solution]

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

[v-yulgu-msft · Accepted solution]

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

[Anonymous]

@v-yulgu-msft

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

Cheers

Shruti

[deepak91g · Accepted solution]

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