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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
CuriousGuy001
Helper I
Helper I

Condition Formatting Colour using Tabular Editor 2

Hi everyone,

I am using Tabular Editor for calculation group, I am stuck in the conditional formatting colour for the value, 

CuriousGuy001_0-1723667291298.png

I am tying to find a way to turn red when the value is negative instead of green colour.

CuriousGuy001_1-1723667342893.png

CuriousGuy001_2-1723667378271.png

 

any help will be appreciate it! 


2 REPLIES 2
Anonymous
Not applicable

Hi @CuriousGuy001 ,

If you want to achieve the effect when the number is greater than 0 the font color is red and the arrow is up, and the number less than 0 the font color is green and the arrow is down, please see this test:

My Table View:

vyetonggumsft_0-1723690122093.png

My Report view:

Please set Font color in the Conditional formatting.

vyetonggumsft_2-1723690122103.png

And please set Icons in the Conditional formatting.

vyetonggumsft_8-1723690438136.png

vyetonggumsft_9-1723690438139.png

Or you can try to replace IN {"MB YoY(% | Diff)"} in the measure value with <0.

 

If I've misunderstood you, please provide detailed sample data and the results you are hoping for. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

 

Best Regards,

Sunshine Gu

Hi @Anonymous,


Don't need to apologize! I am very glad you are helping me and I appreciate it. I did try your solution even inserting "IN {"MB YoY(% | Diff)"} in the measure value with <0" to make the value red but it is not working. I am adding my pbi sample
Link is here: https://drive.google.com/file/d/1NIqibod4QX2N8XssxslFU38avMZnY1F0/view?usp=sharing 

Let me know if you can open, I set it up to public and thank you in advance!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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