cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Conditional formatting in table

Hi,

I have a table in powerBI with various number columns. I would like to indicate with red when the numbers in column A is lower than in column B.

 

I have tried to do that through the conditional formatting but can't get it right.. 

 

 

 

Anybody who knows how?

BEst

Kristoffer

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
jthomson New Contributor
New Contributor

Re: Conditional formatting in table

Make a measure that takes one column from the other, then in your conditional formatting, format the table by that measure by rules. Something like this'll work

 

formatlowernumber.PNG

View solution in original post

2 REPLIES 2
Highlighted
jthomson New Contributor
New Contributor

Re: Conditional formatting in table

Make a measure that takes one column from the other, then in your conditional formatting, format the table by that measure by rules. Something like this'll work

 

formatlowernumber.PNG

View solution in original post

Re: Conditional formatting in table

Ah thanks for the workaround that will do it

Kristoffer

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors