Forum Discussion
PBI_Rookie
Helper I
Helper IInconsistent Conditional Formatting
I have a measure to hightlight values if they are outside spec limits within a matrix. This has been working great for one set of products(Product 1). For whatever reason the upper spec values f...
Hrm, they really should be independent conditions. In the end the result needed is that if it is either below the low spec or above the upper spec I need it to flag.
Hi PBI_Rookie ,
Could you please provide some sample data in table Specifications and Details (exclude sensitive data)and your expected result for product 2 with specific sample and screenshot? Is there any relationship created between these two tables? If yes, please also provide the related information. Thank you.
By the way, the following understanding for the calculation logic of conditional formatting is correct or not?
- if LowerLimitCheck >0 or UpperLimitCheck >0, dispaly the data with the color "#f25a38"
- if LowerLimitCheck is blank, dispaly the data with the color "#04bf9d"
- if UpperLimitCheck <=0 or UpperLimitCheck is blank, dispaly the data with the color "#04bf9d"
Best Regards