Sorting Ascending Quarter month in Bar Chart

Vignesh1609 — Sat, 16 Nov 2024 00:43:43 GMT

Dear All,

Good Day!

I am trying to sort the Quarter Month in Ascending order in Bar Chart, but I cannot sort it properly.

Can anyone guide me in this issue.

I have created the Dimension as "'Q' & CEIL(NUM(MONTH([created date]))/3) &'-'& Month([created date]) ".

Kindly find the attached picture which am facing the issue.

Re: Sorting Ascending Quarter month in Bar Chart

Durgadevikumar — Wed, 13 May 2020 08:03:44 GMT

Hi Vignesh,

Good day😊,

This can be achieved by custom sorting. In bar sort under the sort tab please check the expression box.

In that provide the expression as,

=match(Quarter,'Q1_Jan','Q1_Feb','Q1_Mar','Q2_Apr','Q2_May','Q2_JUn','Q3_Jul','Q3_Aug','Q3_Sep','Q4_Oct','Q4_Nov','Q4_Dec')

And give apply and ok

Your Quarter dimension is automatically sorted as according to order mentioned above.

Hope it is useful to you.

Regards,

DurgadeviKumar