Months compared side by side in a bar chart

Hi, I´m using Grafana in home assistant and my database is influxDB.
I created some bar charts with time range of last 2 or 3 years, as you can see in the picture:

Is it possible to have each month compared side by side to same month from the other years.
For example:
Jan/2023
Jan/2024
Jan/2025
Feb/2023
Feb/2024
Feb/2025

Is this possible?

Thanks for helping me.
Holger

yes it is possible using transformation and unit setting in bar chat panel , please follow the steps..
Step 1: Configure the bar chat visualization panel



Step 2: Add these transformations

image

Final output

Hi, and thank you for supporting me.
I didn´t have the value “Date” in the drop downs or somewhere else. I only have the option “Time”, but when I use Time, instead of Date, it didn´t work.

please share screenshort on table view..


like this


here it is


according to your data use this

Thank you, this is working. For correct sorting I used MM-YYYY and then everything is great. Tank you very much

1 Like

@infofcc3 Maybe you can have a look on my other issue.

Perhaps you have a solution for this too. Hope so

try this…
Interval (GROUP BY time):
time($__interval) → time(1mo)

where exaclty do you mean?

image
here

that doesn´t work

try to change the absolute time range may be problem occured but not sure…

what do you mean with absolute time range?

image
this

nothing changed when changing it there