Matrix column sorting

[Anonymous]

Good day

I am having trouble figuring out a way to implement a matrix for a user to sort by the Pest Count.

The main objective of this matrix is to visualize the pest count for a specific pest on a specific block per week. My user, however,  wants to choose a week and then sort from highest pest count to lowest pest count or vice versa over all values within a week.

Can someone help with this issue?

Regards

[rjhartop]

This blog post may provide what you need:

https://affinityworks.co.uk/power-bi-matrix-column-sort-sorted/

[Anonymous · Accepted solution]

Hi,@Anonymous 

Unfortunately, this feature is not available currently in the matrix.

You can vote for it in Power bi ideas : https://ideas.powerbi.com/ideas/idea/?ideaid=05c64cd1-c0d0-44d3-bceb-21f4acc0e548

Hope it helps.

Best Regards,

Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi

@AlB @amitchandak 

I have tried to do that already. However, it only sorts in descending order per block as can be seen on below figure. I want it to ignore blocks or pest and sort only for the week highlighted from higest to lowest for all pests and then show me that for e.g. Sanitation was the highest at block 270 on week 35.

[amitchandak]

@Anonymous , I doubt you can sort on Individual Column Value  of pivot

[AlB]

Hi @Anonymous 

 Go to the three dots on the top right corner and  choose to sort by the measure you are using in the matrix. Doesn't it work like that? If not share the pbix 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[amitchandak]

@Anonymous , On the three dots, you have option to sort. There you can choose he measure(value) and order.

If that does not help need what is currently there and what is expected.

But you will not able to play around much.

I am hoping you do not want sort Column(pivot) in Descending order.