Compare Actual Result with Target and Last Year result in a visual

[SilviuIL]

Hi guys,

I am having difficulties in creating a visual that compares Actual Result with Last Year result and Target.

In the visual below i want to add a 3rd line that will show the target value:

Actual Result is calculated measure from a table with data at Day Level, that looks like this

and I have a separate table for Targets at Month Level with no relation between them:

Can you please help with a solution?

Thanks

[amitchandak]

@SilviuIL , Create a date in the target table

Date = date([year], [month],1)

or

Date = eomonth(date([year], [month],1),-1)

Join your actual and target with a date table and use that to plot time/date

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos.