Forum Discussion

KPerrySHI's avatar
KPerrySHI
Frequent Visitor
7 years ago
Solved

Sorting by Column Header in Matrix?

Hey Folks,   Hopefully a simple question, but is it possible for users to sort individual columns in a matrix? In this use case we would like to sort by the most orders per row for February, but we...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi KPerrySHI ,

    You do need an custom column to order your columns, but with AS, you could not add any data for your report, the only solution is add the column in AS before you connect it with Power BI or I am afraid you could not custom sort your columns.

     

    Regards,

    Daniel He

  • KPerrySHI's avatar
    KPerrySHI
    Frequent Visitor
    7 years ago

    Sadly, we connect to an Analysis Service which limits our abilities to manipulate the source data, and we can't access the Sort by Column options in the ribbon.

     

     

    Was hoping there would be additional options in the visual, but I appreciate the help.

    • v-danhe-msft's avatar
      v-danhe-msft
      Microsoft Employee
      7 years ago

      Hi KPerrySHI ,

      You do need an custom column to order your columns, but with AS, you could not add any data for your report, the only solution is add the column in AS before you connect it with Power BI or I am afraid you could not custom sort your columns.

       

      Regards,

      Daniel He

    • v-danhe-msft's avatar
      v-danhe-msft
      Microsoft Employee
      7 years ago

      Hi KPerrySHI ,

      Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

       

      Regards,

      Daniel He