line graph with several month measures Y axe's

[bentley32]

Hello folks,

I am trying to achieve the following : 

I needed to create column measures per exemple for each month of sales i have a column in my DB

I made it like this due to performance issue, if i dont i will have 1line X 36 wich brings 720M rows instead of 20M

I achieved what i wanted in the pivot table bellow, but when i do try to make a line graph it became tricky since i do have 36 measures and each one for a month

What i could do its Month in colors and years in the Y axe's

what i need its the month in the Y axes and years in colors

: Thanks for your help

[bentley32]

Some one ? 🙂