"Target" Line on Line and Clustered Column Chart

[SiroPW]

Hi, 

 I have a clustered line and column chart like so:

 

I would love love love to be able to put a "target" line at a constant 85% line.

Usually I could do this easily with the analytics pane but it is completely unavailable for this and I think it is because I am using a custom date table for the X-Axis (I need to use the date table to get the correct sorting).

My other method was to create a measure (measure = 0.85) and place it on as another line. However my result is:

Basically the measure spans the whole length of the date table and does not adjust for my date range filter!

A huge pain, I just want a simple line at 85%.

Thanks

[v-piga-msft]

Hi @SiroPW,

Refer to this blog, there are two methods for us to create the target line.

For your scenario, you could create a caluculated column(column =0.85).

By my test it could be filtered by the date slicer.

 

Best Regards,

Cherry