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 = 0
Best regards,
Yuliana Gu
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
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
