Forum Discussion
KPI Line Chart - Conditional Formatting Required
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,
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.
5 Replies
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 , 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/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3Hi,
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
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,
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,
