Possible to use a measure in conditional formatting?

[Anonymous]

I have a clustered bar chart and I'd like to set a min and max value that formats the bars a different color. The min and max threshold is different depending on slicer values. I have a Measure that calculates the min/max but can't figure out how to say "less than min measure" and "greater than max" measure in the conditional formatting screen.

I'm guessing it's not possible but thought I'd ask. Thanks!

[amitchandak · Accepted solution]

@Anonymous , Conditional formatting has few limitations. On a few visual, it not supported with legends and second measure.

You can use color scale , rule or field value.

For "Field value" create a measure like

Color Measure =
var _min = CALCULATE([Min Measure],ALL(Table))
var _max = CALCULATE([Max Measure],ALL(Table))
return switch(TRUE(),
[Percent %] <_Min , "Red",
[Percent %] >_max , "Green", "Blue")

Refer for steps

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[Greg_Deckler]

@Anonymous Yes, you can use measures in conditional formatting. I believe it is Rules based that you want. Or you can use Field value in Format By

[Anonymous]

Hi @Greg_Deckler.  I need the rule to be in the "Enter a value" section.

[Greg_Deckler]

@Anonymous Sorry, where is the "Enter a value" section? Can you post a screen shot and point to where you mean? You are really better off doing all the logic in your measure as kind of color flag that returns like 1, 2, 3 based on the conditions you set.

[Anonymous]

@Greg_DecklerIn the screenshot you posted. Under the Minimum and Maximum sections. The grey boxes where you enter the min and max values.

[Greg_Deckler]

@Anonymous Nope, can't do that there. That's why I suggested doing the logic in your measure itself to essentially create a flag. 

[Anonymous]

@amitchandakThose links got me pointed in the right direction. Thanks!