Conditional formatting on matrix visual

[Nidhi09031992]

 

This is the data i have suppose i creating a matrix now , rows : Group, Metric  .... Column : Account ,,,,values :kpi value , this table is created in bi now issue is i am not able to do conditional formatting on any metric level coz all values coming from kpi value column frombackend . I tried it with simple matrix with backend tableand one with customized table in BI . 

[GeraldGEmerick]

@Nidhi09031992 A bit hard to decipher the issue you are having. You can create a measure that returns a text color code like "#FF00FF" for example that is based on whatever logic you desire within the DAX code. For example:

Color =
VAR _Metric = SELECTEDVALUE( 'Table'[Metric] )
VAR _Value = SELECTEDVALUE( 'Table'[Value] )
VAR _Return
  SWITCH( TRUE(),
    AND( _Metric = "Gap", _Value > 1000 ), "#FF0000",
    AND( _Metric = "Gap", _Value < 1000 ), "#00FF00",
    AND( _Metric = "Total order", _Value > 3000 ), "00FF00",
    "FFFFFF"
  )
RETURN _Return