Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Font color green/red color based on it's value.

I have a  column/measure with single value. The font color should be green when it's having positive value.otherwise, the font color should be red. 

 

Can anyone give the suggestions to display the value with above requirement ?

11 REPLIES 11
PattemManohar
Community Champion
Community Champion

@Anonymous Please try with "Conditional Formatting" option





Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




Anonymous
Not applicable

I dragged the column in table visulization and wrote conditional formating for font color. I attached the screenshot below.pic1.PNG

 

But the value font color didn't change in the table.

pic2.PNG

@Anonymous Try like this.. (Change your second condition to "is greater than")

 

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




Anonymous
Not applicable

It's not working. Please find below screenshots.

 

pic3.png

 

Pic4.PNG

Pic5.PNG

 

Pic6.PNG

Please check the above screenshots. It's taking the font color from format>Values(check the screenshot3).The font color is not varying bases on conditional formatting.

Anonymous
Not applicable

It's not working. Please find below screenshots.

 

pic3.png

 

Pic4.PNG

Pic5.PNG

 

Pic6.PNG

Please check the above screenshots. It's taking the font color from format>Values(check the screenshot3).The font color is not varying bases on conditional formatting.

@Anonymous Same logic working..

 

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




Anonymous
Not applicable

Could you please provide the visulization type, Format>Values Color also ?

@Anonymous





Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




Anonymous
Not applicable

In my dashboard the value is sum of column values. The conditional formatting is working for indiviual values of column. How to change font color of sum of column values(Total value) based on expression ? 

@Anonymous - Unfortunately I am not aware of a way to conditionally format the total.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

I dragged the column values into table/matrix. I wrote the conditional format but it's not working.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors