Ordering of Legends in Stack bar chart

[Anonymous]

Hi Friends,

I have created a stack bar chart. 

Blue color denotes to : High

Red color denotes to : Low

Yellow color denotes to : Medium

So current ordering is - High, Low, Medium [Ordered Alphabetically]

I want to order it like - High, Medium, Low. But I am not able to do so. 

Kindly help me out to make it done. Thanks a lot in advance.

Regards,

Bhu

[mussaenda]

Hi @Anonymous,

you can create an index for your legend then use sort column by your index column.

Hope this helps.

[Anonymous]

Hi @mussaenda ,

Thanks for your revert.

But I have 3 columns in same table for different stages of Soil Type having High, Medium and Low.

I think your solution will work only for one column. Others 2 will be disordered by sorting index for 1st column.

Is there any other solution using that I can sort 3-4 charts in different stages ???

Thanks.

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

Could you please provide some sample data which used in stacked bar chart in order to provide you a proper solution? If the data have the same structure with the one in below screen shot, you can put the Soil Type fields  in Values fields with specific orders just like the part with red mark.

In addition, you can refer the method in the following links.

Modify the legend order

Custom sort order for axis, columns, legends.... in Power BI

Best Regards

Rena

[amitchandak]

@Anonymous , You can use the same sort column for all three. But you need have a column like

Switch ( True(),

[Col1]="High",1,

[Col1]="Medium",2,

[Col1]="Low",3) // correct the numbers as per need

Step for sort column

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

Also, check, you might not need that

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi