conditional formatting with field value

[Anonymous]

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.

The value of the field is green for postive value and red for negative value (the calculation is a little more complex but the idea is there.

The goal of this formatting is to have a colored staircase

Instead of green I would like to have red for negative value

Thanks for helping

[Anonymous]

@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 · Accepted solution]

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]

@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 "")

[parry2k]

@Anonymous add a measure for color and then use that in conditional formatting -> field value

Color Measure = 
IF ( [My Measure] < 0, "Red", "Green" )

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.