Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sort Columns - Ascending or Descending order in Matrix format - Example attached

Can anyone help me to sort columns within Matrix format - Plumbing and Electrical?

 - I want to sort either Ascending or Descending by clicking Plumbing or Electrical column individually to see highest or lowest values. 

I have attached both orginal data which is the excel spredsheet and created matrix as below.

3 Replies

  • v-evelk's avatar
    v-evelk
    Microsoft Employee
    7 years ago

    Hello,

     

    Your question is unclear and the immage is too small to understand what is going on there.

    Standard Matrix visual lets to sort data by clicking on Column name, also you can choose aggreagation functionf for your values field.

     

    Could you please clarify the issue?

     

    Evgenii Elkin,
    Software Engineer
    Microsoft Power BI Custom Visuals
    [email protected]

      • v-evelk's avatar
        v-evelk
        Microsoft Employee
        7 years ago

        Hello Young,

         

        Thanks for your files, now the issue is clear.

        I suppose that standard Matrix visual doesn't support sorting by an exact value column but I cannot say for sure because it is a core visual (not a custom one).

         

        If you need a matrix with such feature you can check Power BI Visuals Store.

        There is a chance that you find something suitable for you there.

         

        Kind Regards,

         

        Evgenii Elkin,
        Software Engineer
        Microsoft Power BI Custom Visuals
        [email protected]