Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Solved! Go to 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
Hope this helps.
Proud to be a Super User! | |
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.
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.
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.
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
Hope this helps.
Proud to be a Super User! | |
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
76 | |
61 | |
37 | |
33 |
User | Count |
---|---|
101 | |
56 | |
51 | |
45 | |
40 |