Clustered bar chart - sort by year

[jacek_k]

Hi,

is it possible to sort data (quantity) descending just by year 2017 (not sum of 2016 and 2017) without adding extra columns/measures? For instance, Illinois should be above Ohio.

 

Jacek

[Anonymous · Accepted solution]

HI @jacek_k,

Perhaps you can try to extract the field value to create a new calculated table and add sorting index to use it as custom sort order table and link to the raw table field.
Then you can use the new field to replace the raw axis on your chart, then it will apply for custom sort order on your visual graph.

Custom Sorting in Power BI 

Regards,

Xiaoxin Sheng

[jacek_k]

@Anonymous Thank you very much, it works now 🙂

[amitchandak]

@jacek_k , You need create desc sort column and mark that as the sort column for year and then use it

Year 1= [year]

Year sort = Rankx(All(Table), [year],,desc)

Then sort Year 1 om Year sort and use it

I have discussed the same use case for Matrix - https://www.youtube.com/watch?v=KK1zu4MBb-c

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[jacek_k]

@amitchandak we've misunderstood each other. I need to sort states by 2017 quantities only. Using your solution I've reordered years.