Reference lines on chart in % terms

[jlampard40]

Hi all - I have a chart which shows our KPI in % terms, as follows:

=Count([REPKPIData_EventKey])/ Count (TOTAL <REPKPIData_MonthReported> {<[REPKPIData_KPI]>} REPKPIData_EventKey)

There are multiple pathway fields which can be selected (REPKPIData_Pathway) and the data will change on the chart.  I need to show different reference lines on the chart, depending on what the user selects using the above pathway field.  So, if user selects '2WW' I need it to show a reference line at 90%.  If they select 'CT & MRI OP' I need it to show a reference line at 75%...and so on.

I've used the following formula, but it doesn't seem to work.  Any ideas?

If(GetCurrentField(REPKPIData_RepPathway) = '2WW', 90)

Many thanks all!

[jlampard40]

@vinieme12  - are you able to help with this at all?

[vinieme12]

Add another measure which will act as a trendline instead of adding Trendline to a measure

Try with Pick(Wildmatch(

=pick(wildmatch(REPKPIData_RepPathway,'2WW','CT & MRI OP')+1,DEFAULT%,0.9,0.75)