Conditional formatting based on Value Vs. Target

[Chanleakna123]

hi , 

how to set conditional formatting on Bar Chart based on Value Vs. Target ?
if the value < target => Red Bar chart 

if the value > target => Green Bar chart 

thx you 

[v-diye-msft]

Hi @Chanleakna123 

If above posts don't meet your requirements, kindly share your sample data and expected results to me if you don't have any Confidential Information. Please upload your files to One Drive for business and share the link here.

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[amitchandak]

@Chanleakna123 

Create a measure like this

Color Hours = SWITCH(true(),
Sum([Target]) > 10,"green",
"red"
)

You can have more conditions.

I used a clustered chart. There In data Color,  On group by I clicked on advance Control (You will see three dots on hover click on that).

There choose field option in first LOV and choose this measure

[Chanleakna123]

@amitchandak , hi , i have different target in each category , the target not sustain based on month . 

i think above is not work . 

[Greg_Deckler]

@Chanleakna123 - This is where sample data would be very useful.

[amitchandak]

Try

Color Category = SWITCH(true(),
Max(Sheet1[Category]) in {"A",} && Sheet1[Target]<10,"green",
Max(Sheet1[Category]) in {"B"} && Sheet1[Target]<10,"orange"
"red"
)