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

[Anonymous]

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.

[v-evelk]

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
pbicvsupport@microsoft.com

[Anonymous]

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]

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
pbicvsupport@microsoft.com