Forum Discussion

L_trainee's avatar
L_trainee
Frequent Visitor
2 years ago
Solved

graph: How to sort Sort Axis by Date, then another value (count)

Hello,

 

I'm starting on Power BI and so far, after some search, I was able to do most of the things I wanted.

 

However, I've been stuck on one thing for a while: Sort a graph axis by two different data (date first, then count of a string column).

 

Currently my data look like this:

However, I'd like the bar plot to be orderer from biggest to lowest in each category.

So keep the "date" order and, in each date category (Year, month and/or day) have the barplot in descending order.

 

I found this message, which seems a similar problem but I don't understand nor can apply the solution given:

Solved: How to customize sorting a bar chart by two column... - Microsoft Fabric Community

 

Is there a way to do this?

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi L_trainee ,

    Based on my testing, may be impossible to sort the count Category order desc.

    When trying to use the Rankx dax to sort the category, it is impossible to rank the multiple category.

     

    Best Regards,

    Wisdom Wu

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi L_trainee ,

    Based on my testing, may be impossible to sort the count Category order desc.

    When trying to use the Rankx dax to sort the category, it is impossible to rank the multiple category.

     

    Best Regards,

    Wisdom Wu

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