KPI Line Chart - Conditional Formatting Required

[ArchStanton]

Hi,

Is it possible to conditionally format the chart below so when the line falls under 85% it turns red?

I am not using any measures just SUM totals from this simple table:

Thanks,

[v-yadongf-msft · Accepted solution]

Hi @ArchStanton ,

As a workaround, please add a column like below shown:

I think this is the result you want:

Best regards,

Yadong Fang

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

[ArchStanton]

Can someone confirm if it is possible to change the colour of a line if it falls below e.g zero?

If this feature is not available in PowerrBI I'll close the ticket.

Thanks,

[amitchandak]

@ArchStanton , You show a red marker

Create measure

If([AOQS KPI] < [Overall], "green", "red")

use in conditional formatting for BAR visual using field value option. Once done , change it to line

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

[ArchStanton]

Can someone confirm if it is possible to change the colour of a line if it falls below e.g zero?

If this feature is not available in PowerrBI I'll close the ticket.

Thanks,

[ArchStanton]

Hi,

I don't think its possible according to your links to have a line change colour when it dips below a certain number (I don't want different coloured markers, I want the line itself to change).

I've figured out how to Conditionally Format the Card.

Thanks