Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sort values in matrix values

Hi, i have one table with 4 columns like machine, country ,city  and status. pls take a  look at the table: ABC123 Spain Madrid Bad  ABC123 Yoke Yoke Left Critical ABC123 Ireland D...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi Anonymous,

     

    Is this what you want?

    Try measure as:

    Measure = 
IF(
    MAX('Table'[country])="Germany",
    "Really Bad",
    MAX('Table'[status])
)

    The pbix is attached.

     

    Best Regards,

    Link

     

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

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , we can control column sorting(using sort column). But here you are using status as a measure. And in matrix measure sorting can only happen on grand total

 

refer to my video on column sorting

https://www.youtube.com/watch?v=Qv4wT8_P-AA

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi , I have edit my post, I dont want to sort the column instead I want to change the values in the highest level of hierchy.