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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Conditional Formatting based on table

Hey everyone,

I've got the following table:

LaZZaNoVa61_0-1655737580598.png


I'd like to format the first two columns conditionally:
If the of Totaal Omzet is less then Prognose Omzet, then the value should be red. Otherwise green.

Is there a way to do this?

With kind regards,

Lazzanova

1 ACCEPTED SOLUTION
Saap
Resolver III
Resolver III

Hi @Anonymous 

You can create simple measure to check if prognose is higher than total:

 

check = IF(SUM('Table new'[Prognose])>SUM('Table new'[Total]),1,0)
 
Then you go to matrix's visual settings, cell elements and apply background color based on your measure:
Saap_0-1655809287687.png

 

View solution in original post

1 REPLY 1
Saap
Resolver III
Resolver III

Hi @Anonymous 

You can create simple measure to check if prognose is higher than total:

 

check = IF(SUM('Table new'[Prognose])>SUM('Table new'[Total]),1,0)
 
Then you go to matrix's visual settings, cell elements and apply background color based on your measure:
Saap_0-1655809287687.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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