Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
rafaelcosta
New Member

Sorting y axis ascending when using parameter measures

Hello dear Power BI Community.

I'm using a bar chart where the x axis is a regular field and y axis is a field parameter with 3 measures that I can switch with a slicer:

rafaelcosta_0-1693318794596.png

rafaelcosta_1-1693318849756.png

The default sort order of all measures is descending, but i want they to be ascending. When I set the to ascending using the 3 dots on the chart, it works fine. But if I switch to another measure it resets to descending again. Is this a bug? There is any workaround for sorting dynamically all measures?

I appreciate any help!

4 REPLIES 4
trevrobwhite2
Advocate I
Advocate I

Did you ever work out a solution to this?

gavexe
Frequent Visitor

There is a hint exists. Add static but relevant object into Tooltips and sort by it. It won't reset.

mh2587
Super User
Super User

You should create a sorting column for the x-axis labeled and then put the desired numbers against each label in the new column after that click on sort by column and then select the product column and sort it with the new calculated column


Did I answer your question? If so, please mark my post as a solution!


Proud to be a Super User!




LinkedIn Icon
Muhammad Hasnain



Hi @mh2587, thanks for the tip but that will work for the x-axis only. I want the y-axis asceding for all measures inside the field parameters.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.