The column total value font color based on expression

[Anonymous]

We are using conditional formatting option to modify font color of column individual values.

but in my requirement the total value of column font color should vary based on expression. we aren't displaying individual values of cloumn.  we directly displaying sum of all column values. The font color should be green when column total value is gretaer than zero. Otherwise, it should be in red color.

 Is it possible in power bi ?

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Based on my test, it is not supported to apply conditional color formatting to total values in a table visual. You could use KPI as a workaround.

New below measures:

Total Value = CALCULATE(SUM('table'[Trending Executed]),ALLSELECTED('table'))

target = 0

Best regards,

Yuliana Gu