Power BI chart with target line

[dv1407]

Hello, I would like to make a diagram showing the actual and the target line (green), as shown in the photo. How do I get that in PowerBi? The image is from Excel.

I tied a sharepoint list in which it counts the lines with the status "Done" and these are then provided with a month. Now the target line must count all rows and distribute them over 12 months.

[dv1407]

Hello, please help me a little bit more.

What would be the right choice in Analytics to get the line? Here is the calculation for each month. I'm still missing the filter for the "Done" status here, how do I get that into the formula?

Laufende Summe von Anzahl von field_8 in Monat =
CALCULATE(
COUNTA('tbl_turnus_aufträge'[field_8]),
FILTER(
CALCULATETABLE(
SUMMARIZE(
'tbl_turnus_aufträge',
'tbl_turnus_aufträge'[Modified].[MonthNo],
'tbl_turnus_aufträge'[Modified].[Monat]
),
ALLSELECTED('tbl_turnus_aufträge')
),
ISONORAFTER(
'tbl_turnus_aufträge'[Modified].[MonthNo], MAX('tbl_turnus_aufträge'[Modified].[MonthNo]), DESC,
'tbl_turnus_aufträge'[Modified].[Monat], MAX('tbl_turnus_aufträge'[Modified].[Monat]), DESC
)
)
)

[Kishore_KVN]

Hello @dv1407 ,

In Power BI Desktop create a line visual and create a target line with the help of Analytics tab and it will help you to create a target line. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!