The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
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" 🙂
@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