Sort Data in Bar Chart: years are next to each other for every month

[ren_01]

Hi!

I was trying to create a bar chart that would show the comparison of rainfall (of all months) for every year. And I need that a specific month (for example: January) with different years sit next to each other as seen below. But that only applies when I clicked 1 month in the filter pane.

If I clicked 2 months in the filter pane, the sorting would be (Jan 2018, Feb 2018, Jan 2019, Feb-2019) instead of Jan 2018, Jan 2019, Feb 2018, Feb 2019.

Thank you!!

[vinieme12]

Use two dimensions

1st) Year

2nd) Month

don't use YearMonth dimension

[rubenmarin]

Hi, in the chart properties-> sorting tab, you can add a sor by expression and use Min(MONTH), so it will be sorted first by month and then by date.

To do this MONTH has to be a numeric or Dual(), if doesn't works try adding a field with Moth in number on the calendar and use this field in the sorting.