Time Series Chart With Different Goal For Each Month

[Anonymous]

Hello Dear Community, 

Can someone help me understand if it is possible to create a chart like the one here in Power BI?

My main concern is with regards to the red line, that indicates a different target for each month. 

apoligies if this has already been posted, 

Atanas

[amitchandak]

@Anonymous 

You can have a goal in the table, join the same time dimension. In case data is at the month level. Use the month start date.

You can use line and clustered chart.

[Anonymous]

@amitchandak 

Thank you for your swift reply!

would you please clarify a bit? Should this be a calculated column? 

you're correct summing my data is based on monthly distribution and I understand which chart to use, but cannot understand how to assign the goal for each month.

all due respect,

Atanas

[amitchandak]

@Anonymous , You already have goal for each month or do want to define it using DAX?

[Anonymous]

@amitchandak ,

I already have it, it is on the bottom of the table, below the graph. the red lines visually represents it.

Please let me know if you need some more information.

Thank you,

Atanas