Forum Discussion

raju8004212's avatar
raju8004212
Frequent Visitor
1 year ago
Solved

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 order...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    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.

     

v-echaithra's avatar
v-echaithra
Community Support
1 year ago

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.