Clustered Column Chart: Sorte Order

Question

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

rajulshah · Answer

Hello&nbsp;Anonymous&nbsp;,&nbsp;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.

az38 · Answer

Anonymous&nbsp;a good solution could be is to use grouping&nbsp;https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binningcreate 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

anonymous · Answer

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&nbsp;

v-diye-msft · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
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&nbsp;
&nbsp;
&nbsp;

anonymous · Answer

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.

Forum Discussion

Clustered Column Chart: Sorte Order

8 Replies

Related content

Clustered column chart incomplete legend

Need a stacked clustered column chart

Multiple line and clustered columns chart

Clustered column chart question

Power BI Clustered Column Chart Legend Behaviour