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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
emmalim
Frequent Visitor

How to set the conditional formatting colour when the column is text

Original post: Matrix computed row - to show computed columns wit... - Microsoft Fabric Community

 

Hi @v-cgao-msft, I encounter another issue whereby when I want to set the font colour based on value:
<0, show as red
>0, show as green
But the condition setting determine the column 'Actual - Plan' as Text:

emmalim_0-1692673549924.png

 

I will need to set as below:

emmalim_1-1692673549861.png

Appreciate your kind support to share the solution, thank you very much!

7 REPLIES 7
parry2k
Super User
Super User

@emmalim isn't this what you want?

 

parry2k_0-1692754523731.png

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

@parry2k  I need to applied the colours to column Actual - Plan. But this column is seems like detected as 'text', hence I cannot apply the conditional formatting as per column _Actual 2.
Appreciate your support to share the alternative, thank you very much.  

emmalim_0-1692755159882.png

 

 

parry2k
Super User
Super User

@emmalim why -ve is in red and +ve in green, although I think you want it the opposite, no?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k
Super User
Super User

@emmalim is this what you are looking for:

 

parry2k_0-1692753539647.png

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

@parry2k Thanks for your reply. Unfortunately this is not what I'm looking for, sorry for not being precise in the earlier post. The desire result is as per column _Actual 2 below, but i need it to be applied to column Actual - Plan:

emmalim_0-1692754007233.png

BI file:

P&L Sample_v2 

 

  

Idrissshatila
Super User
Super User

Hello @emmalim ,

 

Yes, you can't set the Actual plan as >0 or < 0 because you merged the columns so it is considered text and not number.

 

it's either you subtract them or sum them to have a number value then you could do a conditional formatting based on what you've mentioned.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




@Idrissshatila  Thanks for your reply. I actually substract 2 measures. Attached the file for your reference. Appreciation your kind support to advice the alternative to show the conditional formatting colour.

BI file:
P&L Sample  

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors