Forum Discussion
Order a graph by dynamic measures
Hello guys,
So, I have some graphs using dynamic measures, but I want to order these graphs always by the dynamic measure and not by the y-axis
Summarizing, I want to be like this, with the x-axis going from 1 to 7:
But everytime I change the measure, to "Regiao", for example, and I get back to "Renda" the graph order by "total operations", my y-axis
Can I always order by the dynamic x-axis measure in Power BI?
4 Replies
caique_aquatico , Create a measure on which you want sort the axis and use that on tooltip and use that as sort column.
Ideally, measure sort works well, not the axis sort. But you can try this solution in case of measure too
Power BI Field Parameters, Keep Axis Sort intact| Always Sort on X-Axis/Categorial Axis: https://youtu.be/GfBrB6czByw
Modify it work for measure in your case
You're using field parameters, right? The only way I've found to do this is a janky workaround involving bookmarks. Here's a video on how it works (it's in the second half): https://youtu.be/Nt3QgZrJXfY
I realize this response is almost two years old but it helped me today. One of these days I hope bookmarks can be done dynamically/programmatically (or maybe they can and I'm just behind), but this helps for what I'm doing. Thanks!
New news! As of the July 2025 update, you no longer have to do janky workarounds for the field parameter sorting - it officially just "works" 🙂
