Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Matrix column sorting

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

 

 

Need Help
Tips and Tricks

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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.

  • AlB's avatar
    AlB
    Community Champion
    5 years ago

    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 

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

     

    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's avatar
      amitchandak
      Super User
      5 years ago

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