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