Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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....
  • v-yulgu-msft's avatar
    8 years ago

    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