cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Patron

## 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
Post Patron

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
)

The formatting looks like

Regards

JFM_12

4 REPLIES 4
Post Patron

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

Resolver I

Resolver I

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

Post Patron

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
)

The formatting looks like

Regards

JFM_12