topic Sort Columns - Ascending or Descending order in Matrix format - Example attached in Custom Visuals Development Discussion

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

Anonymous — Thu, 18 Apr 2019 03:43:39 GMT

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.

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

v-evelk — Fri, 19 Apr 2019 15:10:50 GMT

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

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

Anonymous — Tue, 23 Apr 2019 01:53:42 GMT

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

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

v-evelk — Tue, 23 Apr 2019 14:28:09 GMT

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