Forum Discussion
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. ...
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
parry2k I try to add a mesure for color,
color_mesure = if(SELECTEDVALUE('public stockview'[end_day_stock]) >= 0, "#32CD32", if(SELECTEDVALUE('public red_emergency_view'[stock restant + appro]) >= 0, "#FFA500", "#FF0000"))
But I have only the color green or orange, I have orange color for value 'public red_emergency_view'[stock restant + appro] < 0
- v-easonf-msft
Community Support
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