Forum Discussion
The column total value font color based on expression
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 ?
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 = 0Best regards,
Yuliana Gu
1 Reply
v-yulgu-msftMicrosoft Employee
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 = 0Best regards,
Yuliana Gu