Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Conditional format of a Value

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

Need Help
  • pxg08680's avatar
    pxg08680
    8 years ago

    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.

2 Replies

  • pxg08680's avatar
    pxg08680
    Icon for Resolver III rankResolver III
    8 years ago

    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.