Line Chart with grouping by months and graphs per year

Hey Grafana Community,

im new here because i am struggling the last days with a as I believed simple new requirement.

Currently i’m using the 11.2.2 Version on a Windows Server to create some timeseries Dashboards which are working great.

But now i have a table with a single Measure Value per Month.
The table contains last 12 years.

My target was to create a visualization to compare the monthly for all years.
On the x-Axis should be the months (1-12) and the measure value on the y-axis.
Up to here everything works fine, but when i try to get a single graph for every year i’m failing miserably.

I’ve tried everything, different variations Data Transformation, Trend Visualization, Timeline Visualization. I can’t believe, that this should be so complicated.

My Base SQL Statement ist:

select
month, year, sum(measure)
from table
group by month, year

Isn’t there any proper solution for a simple line chart with a graph for every year?

select year, sum(measure)
from table
group by year

You want it by year right?

thanks for your reply, yes i want a graph per year but also need the month on the x-axis.
Goal ist to compare the month values over the years.