How do I sort my x-axis by both value and region? [urgent help required]

[delta1995]

Hi community,

I am looking for a way to sort my axis by 2 fields: by region and by value. I basically have the chart below where I have different customers running along the x-axis. Each customer belongs to a territory - either ROI or NI. Each customer also has a volume associated to them, which I have put in the tooltips. 

I want to be able to separate/group the customers by their territory i.e. ROI or NI, and within each territory be able to sort the customers from highest volume to lowest volume. Right now, the sort function only allows me to sort by one dimension: either by volume or by territory but I need a two dimensional sorting.

Can anyone help please?

[delta1995]

Hi Dhairya, thanks for responding to my post. I have seen this blog post before but the sort by multiple columns only applies to a table no? I want to sort my stacked column chart.
Essentially I want my NI customers to be placed next to each other but sorted by volume, and then my ROI customers to be placed next to each other and sorted by volume, and I want all of this in one single chart. Right now, I can only sort by one dimension, so if choose to sort by volume, my NI and ROI customers are no longer grouped together. 

[Dhairya]

Hey, @delta1995 You can try converting your chart to the table then sort that table and convert it back to chart may be this can help.

[Dhairya]

Hey @delta1995 

https://learn.microsoft.com/en-us/power-bi/consumer/end-user-change-sort

Please find "Sort by multiple columns" section in above blog.

If this helps you than please give a kudo and mark my solution as accepted so that other can find it quickly.