Forum Discussion
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?
- Anonymous2 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
- AnonymousNot 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.