Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

conditional formatting with field value

Hi,   I realised a matrix with a value switched to row. I try to format the row with field value but I have a problem with the summarization who take the first or the last value for the all row. ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    3 years ago

    Hi, Anonymous 

    If the data value for this field is aggregated, please try again using 'SUM' instead of "SELECTEDVALUE".

     

    Best Regards,
    Community Support Team _ Eason

Anonymous's avatar
Anonymous
Not applicable
3 years ago

parry2k I use this column for conditional formatting -> field value but it doesn't work because of the summarization

= Table.AddColumn(#"Colonnes renommées", "couleur", each if [end_day_stock] >= 0 then "#32CD32" else if [#"stock restant + appro"] < 0 then "#FF0000" else if [#"stock restant + appro"] >= 0 then "#FFA500" else "")