Skip to main content
cancel
Showing results for 
Search instead 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

Reply
Heinrich
Post Patron
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

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

Bibiano_Geraldo
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
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 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors