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
Heinrich
Post Partisan
Post Partisan

Conditional Formatting based on calculation of different tables

Hello

I would like to do a conditional formatting based on calculation of 3 differen values

 

i.e. 

if table a is less than the value of 10

and if table b is less than the value of 5

and if table c is less than the value of 14

 

than put the background of table z to red

 

is that possible?

 

Regards

 

JFM_12

1 ACCEPTED SOLUTION

Hello
Hope you had a great weekend

I tried this with following script

_Video_Poor_Percentage = IF(
    SUM(CQD[Video Local Frame Loss Percentage Avg]) > 50  &&
    SUM(CQD[Video Frame Rate Avg]) < 7 &&
    SUM(CQD[Audio Post FECPLR]) > 0.15 ,
    1,
    0
)
 
But received following error
Heinrich_0-1702883996935.png

 

The formatting looks like

Heinrich_1-1702884033853.png

 

Regards

 

JFM_12

 

View solution in original post

4 REPLIES 4
Heinrich
Post Partisan
Post Partisan

Hello Bibiano_Geraldo
Thank you very much.
Can this also be done with data which is accessed to on Direct_Query.
Greetings
JFM_12

Bibiano_Geraldo
Super User
Super User

Yes, its Possible, Try To follow this steps:

1. Create a measure like this

 

Measure =
IF(
    SUM(Table_A[Your_Column]) < 10 &&
    SUM(Table_B[Your_Column]) < 5 &&
    SUM(Table_C[Your_Column]) < 14,
    1,
    0
)
 
2- In your table_Z, right click in values that you want to highlight and choose format condition - Background, and then choose rules and drag the created measure to fileds based on, and put something like the screen bellow
Bibiano_Geraldo_0-1702465071273.png

 

 

Hello
Hope you had a great weekend

I tried this with following script

_Video_Poor_Percentage = IF(
    SUM(CQD[Video Local Frame Loss Percentage Avg]) > 50  &&
    SUM(CQD[Video Frame Rate Avg]) < 7 &&
    SUM(CQD[Audio Post FECPLR]) > 0.15 ,
    1,
    0
)
 
But received following error
Heinrich_0-1702883996935.png

 

The formatting looks like

Heinrich_1-1702884033853.png

 

Regards

 

JFM_12

 

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.