Combo chart with multiple filtered lines

[TODEI]

Hej Power BI community,

I am trying to compare multiple forecasts with each other including the actuals as columns. 

My data looks as following:

Year & Month	Planning Period	Actual m³	Forecasted m³
2022 May	2022 May	1000	1100
2022 May	2022 Jun	1000	1000
2022 May	2022 Jul	1000	1000
2022 Jun	2022 May	1200	1150
2022 Jun	2022 Jun	1200	1250
2022 Jun	2022 Jul	1200	1200
2022 Jul	2022 May	0	1300
2022 Jul	2022 Jun	0	1350
2022 Jul	2022 Jul	0	1320

...

So basically, any Year Month combination that hs already passed during planning has the actuals instead of a forecast. 

Now what I would love to do is have one line for each planning period (forecast) and one column per month for the actuals. I created a new actuals using this formula so it does not add up different months actuals. 

m3 Single = Divide([m3 Actuals], IF(ISFILTERED(Table[Planning Period]), COUNTROWS(VALUES(Table[Planning Period])),0))

This is pretty much the outcome I want:

To achieve this I had to create one measure per forecasting round. Also, each measure I do not have active or that is filtered out still gets shown on the legend. This is the formula used:

m3 2021 Sep = CALCULATE([m3 Forecast],Planning Period[Planning Period]="2021 Sep")

Since I have atleast 20 planning periods per year I would love not to create a measure for each line. Is there any option to do this?

I found one visual by modular GmbH that does this. Sadly it always aligns the actuals with a different Axis and I cannot seem to get the axes to align.

Thank you very much for your help!

[Anonymous]

Hi @TODEI ,

Please review the following blog, hope they can help you.

Using R script visual:

R – POWER BI – ADD TARGET MARKER TO EACH BAR IN A GROUPED BAR CHART

Create a Combination Chart in Power BI: Bar Chart with Line

Best Regards