Conditional formating

[ktt777]

Hi , 

How can i make a conditional formating that is more dynamic , based on target , not a fixed number

I would like to have the performance be red if it less than target when i filter for different country

https://1drv.ms/u/s!ApIDnMK2eKiFgQXmusmux50Amuqw?e=fJedro

thanks 

[amitchandak]

@ktt777 , refer

Color Measure - Conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

[jdbuchanan71 · Accepted solution]

@ktt777 

Write a formatting measure that compares the amounts and returns the color based on the result.

Formatting = 
VAR _compare = SUM ( formating[performance ] ) - SUM ( formating[Target ] )
RETURN 
SWITCH (
    TRUE(),
    _compare > 0, "Green",
    _compare < 0, "Red",
    "Grey")    

Then set the conditional formatting based on the measure:

[AllisonKennedy]

You just need to create a measure that does
[Actual]-[Target]

Then use that measure to apply your conditional formatting, Red if less than 0.