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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
aoghelian
New Member

conditional highlight higher value between two columns

Hello! i have a table called totalsCalcs 

that has two columns 

aoghelian_0-1686951056370.png

i'm trying to apply conditional formatting to the "Actual" and highlight in green if the cell value is lower than the cell value of "Amount" in the same row

I appreciate any help i can get!!

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

pls try this

Screen Capture #1263.pngScreen Capture #1264.pngScreen Capture #1265.png

you need to repeat this for all fields :

Order    Months    SUM of  Amount       SUM of Actual

 

Sample PBIX file attached

conditional highlight.pbix

 

View solution in original post

1 REPLY 1
Ahmedx
Super User
Super User

pls try this

Screen Capture #1263.pngScreen Capture #1264.pngScreen Capture #1265.png

you need to repeat this for all fields :

Order    Months    SUM of  Amount       SUM of Actual

 

Sample PBIX file attached

conditional highlight.pbix

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors