Conditional Formatting

[renecornish]

Hey, I need some help with conditional formatting.  I have two measures, one TARGET and the other the actual MEASURE.  I am wanting to change the colour of the bar to GREEN if the measure was achieved and RED if not.  How would I go about doing this?

I would presume under Data colours, but there is no options there?

[renecornish]

What I ended up doing which worked well was creating 2 measures...

1. Green = IF(SUM([MEASURE])<=SUM([TARGET MEASURE]),SUM(MEASURE]),0)
2. RED = IF(SUM([MEASURE])>SUM([TARGET MEASURE]),SUM(MEASURE]),0)

This way I was able to do conditional formatting on these results.

[v-lili6-msft]

hi  @renecornish 

If you put two or more measure into one chart visual, you could not use conditional formatting any more.

so when you just use one measure then you could add a new measure like this: Measure = if([ACTUAL] >= [TARGET] , "Green","Red")

then use it to conditional format it.

if you still have the problem, please share your sample pbix file and your expected output.

Regards,

Lin

[amitchandak]

@renecornish , Create a color measure and use that in conditional formatting using "Field Value" Option

Measure = if([ACTUAL] >= [TARGET] , "Green","Red")

refer for steps

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

[renecornish]

What I ended up doing which worked well was creating 2 measures...

1. Green = IF(SUM([MEASURE])<=SUM([TARGET MEASURE]),SUM(MEASURE]),0)
2. RED = IF(SUM([MEASURE])>SUM([TARGET MEASURE]),SUM(MEASURE]),0)

This way I was able to do conditional formatting on these results.

[Anonymous]

https://community.powerbi.com/t5/Desktop/Conditional-color-formatting-overview/td-p/329137

https://docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting

I hope this helps. 🙂