topic Bullet Chart - Adding Measure as Target Value in App Development

Bullet Chart - Adding Measure as Target Value

bdoucet — Thu, 30 Nov 2023 17:15:26 GMT

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?

Re: Bullet Chart - Adding Measure as Target Value

Lisa_P — Wed, 06 Dec 2023 01:51:28 GMT

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.

Re: Bullet Chart - Adding Measure as Target Value

Aasir — Wed, 06 Dec 2023 04:36:02 GMT

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

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