Calculate SLA percentage and insert line value

[SM_1997_]

Hello,

I am trying to divide the count of "taskslatable_has_breached" filtered by false by the count of "inc_number" and display it as a percentage that can be displayed as the line value in a line and clustered column chart. 

Edit: Also, is it possible to insert a measure for "line values" in a clustered column chart?

Edit2: I tried using this solution but it said that it couldn't display the visual when I putthe measure in for "line values"

I have attached a screenshot of basically what I'm looking for.

   

[v-stephen-msft · Accepted solution]

Hi @SM_1997_ ,

I tested on my side. And the measure can be put into Line values.

If the measure cannot be displayed, please try to change the visual to a table visual to see if the measure has values. It may be that the measure is written incorrectly.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.