Column Chart X - axis

[AdamMetz23]

Hi Dear Community,

May I ask for your expertise with regards to a column chart visualization where there are two levels on the X-axis:

1. Region

2. Country:

There are two things I would like to do but so far I could not fint a solution after various attempts:

1. The values should be in descending order within each separate Region. For Example, in ESARO South Sudan should be the first followed by Ethiopia or in ECARO region Ukraine should be first followed by Turkiye.

2. The color of the columns should be different by Region. For Example, EAPRO columns should be green while ECARO columns should be red etc.

May I ask for your help how to implement these changes?

Thank you a lot for your help in advance and have a great day,

Adam

[miTutorials · Accepted solution]

1. Are you not able to sort the chart by the value field and choose Descending ? That should help you sort in Descending order.

2. Under Format tab - You can manually choose all the countries under the region and choose the color of your choice.. Hope this helps !

[AdamMetz23]

I could solve the number 2 coloring by using conditional formatting on columns based on Field Value. For example if text is EAPRO then red etc.

I would be grateful if someone could help with number 1 though. 🙂 Thank you.