Conditional format of a Value

[Anonymous]

Hi,

i'm using a Custom Visual - VitaraCharts Microchart - and i would like to know if it's possible to change the color in this and in other custom/MS visuals in a flexible way, via PBI options (quick metric?) or DAX:

Imagine that you have metrics realvalue, minvalueexpected e maxvalueexpected, all in the values area.

Is it possible to do a conditional format like this:

realvalue < minvalueexpected => realvalue appears in red

minvalueexpected < realvalue < maxvalueexpected => realvalue appears in green.

Regards

[pxg08680 · Accepted solution]

@Anonymous

You can use IF statement.

Column = IF(Table[RealValue] < Table[MinValue], 1, 0)

Drop this new column into visual and apply conditional formatting. If 1 red color , 0 green.

Hope this helps.

[parry2k]

check this link, I guess it will help.