KPI line query

[Bando]

Quick query. I'd like to add a KPI line on the y2 axis (%SLA) at 95%. Is there a simple way to do this or is it a case of creating another column of data with the KPI in against the values on the x-axis?

[WillT]

You can also use a reference line for this. Go to the formatting pane (look for the paintbrush icon under the viz icons) and there's a card there for it. HTH!

[Bando]

I'm revisiting this again and there is no reference line option for this type of combo chart. I've also tried using calculated columns in my data but because I'm agragating the data by months with different numbers of rows in each monthe it also calculates the % for the targets too.

[Greg_Deckler]

You could try just creating a measure and setting its value to 95% and then putting that on your Y2 axis.