Forum Discussion
Heinrich
Post Partisan
Post PartisanConditional 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
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 errorThe formatting looks like
Regards
JFM_12
4 Replies
- Bibiano_Geraldo
Super User
Yes, its Possible, Try To follow this steps:
1. Create a measure like thisMeasure =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
HeinrichHello
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 errorThe formatting looks like
Regards
JFM_12
- Heinrich
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
Yes, try this topic if can help you.
