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 high...
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]

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello Evgenii,

 

Thanks for your response. I have shared sample data with the Excel, Power BI and screenshot that shows what I would like to try. Please find them from the below link, and let me know if you are still confused (I have done my best but still frustated as I am new to this).

 

https://drive.google.com/drive/folders/1dGsnq8yrWx1pRAXAXnhgRVNKMh-Xmmeh?usp=sharing

 

Regards,

Young

  • 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]