Clustered Column Chart: Sorte Order

[Anonymous]

I am creating a clustered columns charts, I want to order it by the legends not the value and axis. is it possible?

[Anonymous]

In this chart, I want to be able to customize the order of time periods as well as the A,B,C things to be able to create some thing like B,A,C

[v-diye-msft]

Hi @Anonymous 

Do you mean you'd like to re-order the axis? could you please kindly specify more details about the data type in your sample?

Below post can be your reference:

https://community.powerbi.com/t5/Service/Re-ordering-the-x-axis-values/td-p/82768 

[Anonymous]

The data masked as a,b,c,d are of text format and the legends (current month, L3m etc) are also text in nature. The data shown in charts is a measure in itself.

[v-diye-msft]

Hi @Anonymous 

You can change the sort order, but it should be sort by one measure which defines the rules, please kindly share your dummy pbix/simple file that i can check it further and provide a valuable solution. 

[Anonymous]

I want to sort basis A,C and B basis sort order.

[Anonymous]

So to explain better, I want to be able to control that TY goes to the right and YA to left. Also, if possible I want to customise the order of my x-axis elements. I can't use sort by because it is not basis values or alphabetical order

[az38]

@Anonymous 

a good solution could be is to use grouping https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning

create groups with one item (one group for each item) and call it like "0 - item 1", "1 - item 2", etc..

do not hesitate to give a kudo to useful posts and mark solutions as solution

[rajulshah]

Hello @Anonymous ,

It will automatically sort the legend by alphabetical order. Or you can drag the field in Tooltips section and you will then be able to sort by the legend field.