Bullet Chart - Adding Measure as Target Value

[bdoucet]

I'm trying to create a bullet chart comparing current year to prior year totals and I'd like the target line to be the prior year totals. I see the option to add a target but you either need to hardcode a static value or write a new function. Is it possible to use a measure from the mater items as the target value?

[Lisa_P]

Depending on your version, you should be able to use your measure as the Target value.

If you open the expression editor for the Target start typing the measure name and you should find it.

[Aasir]

Define a variable using the below expression and use it as target variable in the bullet chart.

Sum({<Year={"$(=Max(Year)-1)"}>} YourMeasure)