Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sort the fields in a matrix

Hi, 

 

I want to know if it is possible to easily sort the order in my matrix : 

 

Thanks 

 

Best Regards 

Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous ,

    For your requirement, you could create a conditional index column in Query Editor and then sort the column age group by the conditional index column under modeling tab.

    Here is the output.

    For more details, please refer to my attachement.

    Best Regards,

    Cherry

     

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    7 years ago

    Are you referring to the ordering of your columns or your rows? Rows you can sort by clicking on the column header or using the ellipses. If you are referring to your columns would have to understand more about your data and how that matrix is built. Are those individual columns or soemthing else? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I refer to my columns order. My matrix is build like that : 

      Assignment group = an individual column

      Age group = a calculate column

      Backlog = a measure 

       

      The order that I want is : 01-02 days / 02-07 days / 07-14 days / > 14 days 

      • v-piga-msft's avatar
        v-piga-msft
        Resident Rockstar
        7 years ago

        Hi Anonymous ,

        For your requirement, you could create a conditional index column in Query Editor and then sort the column age group by the conditional index column under modeling tab.

        Here is the output.

        For more details, please refer to my attachement.

        Best Regards,

        Cherry