sorting issue

[raju8004212]

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

[v-echaithra]

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]

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]

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 · Accepted solution]

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.