Want to add a target line to bar chart based on a percentage measure

[ChrisAZ]

So I am looking to add a line that runs across the months that shows the level based on 70% of the dark blue bar (Paid Hours). I know I need to create some kind of measure and then place it in the Line y-axis space, but I cannot figure out how to get basically 70% of Paid hours. Can someone advise on what that measure would look like?

[Gabry · Accepted solution]

Hello @ChrisAZ ,

your new measure should look like this:

70%paidhours= [paidhoursmeasure]*0.7

if you need to calculate the 70% of the year instead of the current month shown in the graph you can do like this:

Var _year=year(selectedvalue('dates'[date]))

return

calculate([paidhourmeasure])*0.7, all('dates'), 'dates'[year]=_year

[ChrisAZ]

Thank you so much!