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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
raju8004212
New Member

sorting issue

if i place max(sales) in x-axis and customer name into yaxis and orderyear into legend in bar chart of power bi im not able to sort the visual its giving random sort

i have tried making with orders table of sample superstore suggestions please

1 ACCEPTED SOLUTION
rajendraongole1
Super User
Super User

Hi @raju8004212  -yes, this is a known limitation with Power BI. Power BI cannot sort by a measure across all legend categories. If you want to still use the legend (e.g. Order Year), then create a ranking measure per customer based on total or max sales, and use that to sort your Y-axis (Customer Name).

 

create as like 

Customer Rank =
RANKX(
ALL('Orders'[Customer Name]),
CALCULATE(MAX('Orders'[Sales]))
)

Then go to your Customer Name column, and in the Modeling tab, set "Sort by Column" = [Customer Rank].

Now your Y-axis (Customer Name) will sort according to max sales despite the legend.

 

solved reference links:

Stacked bar chart won't sort properly with value i... - Microsoft Fabric Community

Sort Legend in Power BI

 

Hope this helps.

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

4 REPLIES 4
v-echaithra
Community Support
Community Support

Hi @raju8004212 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,
Chaithra.

v-echaithra
Community Support
Community Support

Hi @raju8004212 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,
Chaithra.

v-echaithra
Community Support
Community Support

Hi @raju8004212 ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,
Chaithra.

rajendraongole1
Super User
Super User

Hi @raju8004212  -yes, this is a known limitation with Power BI. Power BI cannot sort by a measure across all legend categories. If you want to still use the legend (e.g. Order Year), then create a ranking measure per customer based on total or max sales, and use that to sort your Y-axis (Customer Name).

 

create as like 

Customer Rank =
RANKX(
ALL('Orders'[Customer Name]),
CALCULATE(MAX('Orders'[Sales]))
)

Then go to your Customer Name column, and in the Modeling tab, set "Sort by Column" = [Customer Rank].

Now your Y-axis (Customer Name) will sort according to max sales despite the legend.

 

solved reference links:

Stacked bar chart won't sort properly with value i... - Microsoft Fabric Community

Sort Legend in Power BI

 

Hope this helps.

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.