Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have the following table set up. I want to set up conditional formatting that highlights cell values based on the following criteria.
If Sales A is greater than or equal to 5 highlight blue.
If Sales B is greater than or equal to 10 highlight blue.
That's simple for me to do BUT here is my problem.
If Sales A is greater than or equal to 5, Sales B automatically highlighted blue regardless of value against Sales B.
If there is no value against Sales A, then the conditional formatting for Sales B (that is, if greater than or equal to 10 highlight blue) applies.
If the sum of Sales A and Sales B is greater than 12 highlight both Sales A and Sales B blue regardless of other formatting conditions.
Hope this makes sense.
Site | Sales A | Sales B |
Strawberry Fields | 64 | 7 |
Mango Orchard | 4 | 7 |
Vegie Patch | 3 | 9 |
Solved! Go to Solution.
Wonderful - now are you able to tell me how I combine the two formulas into one DAX measure please.
Wonderful - now are you able to tell me how I combine the two formulas into one DAX measure please.
Hi @DianneB ,
Please try these measures.
Color_A =
var _a = SUM('Table'[Sales A])
var _b = SUM('Table'[Sales B])
return IF(_a + _b <= 12 && _a < 5, BLANK(), "blue")
Color_B =
var _a = SUM('Table'[Sales A])
var _b = SUM('Table'[Sales B])
return IF(_a + _b <= 12 && _a < 5 && _b < 10, BLANK(), "blue")
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have another question please - I have worked out the formula with your help but now want to use the same criteria to highlight costs but when I do so, blank cells will highlight because whilst the criteria will apply and only highlight cells which meet the criteria when I use as described, when I apply to something else even all cells highlight even if blank. Does this make sense?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.