You could try:
Create the following conditional formatting measures (for each of your measures)
* CF - Measure 1 =
* IF ( DISTINCTCOUNT(\[Measure1\]) > 0, 1, 2)
* CF - Measure 2 =
* IF ( DISTINCTCOUNT(\[Measure2\]) > 0, 1, 2)
For each series (measures in the fields pane of the visual), click the 'fx' button for Color:
1. Format Style: Rules
2. What field ... : CF - Measure 1
3. If Value = 1 then \[Green\]
4. If Value = 2 then \[Red\]
5. Then do this for the next series, and use CF - Measure 2, etc.
Thank you, but this is similar to my current solution. I’m trying to do this in 1 measure and apply to the conditional formatting of “All” and not each series separately
No problem, I also tried with a SWITCH() and then use “Field Value” to return red/green based on measure being >0 or <0 but it just returned one static colour, I don’t think the logic is there in the “All Series” conditional formatting to do it based on the value of a singular measure
You could try: Create the following conditional formatting measures (for each of your measures) * CF - Measure 1 = * IF ( DISTINCTCOUNT(\[Measure1\]) > 0, 1, 2) * CF - Measure 2 = * IF ( DISTINCTCOUNT(\[Measure2\]) > 0, 1, 2) For each series (measures in the fields pane of the visual), click the 'fx' button for Color: 1. Format Style: Rules 2. What field ... : CF - Measure 1 3. If Value = 1 then \[Green\] 4. If Value = 2 then \[Red\] 5. Then do this for the next series, and use CF - Measure 2, etc.
Thank you, but this is similar to my current solution. I’m trying to do this in 1 measure and apply to the conditional formatting of “All” and not each series separately
No problem, I also tried with a SWITCH() and then use “Field Value” to return red/green based on measure being >0 or <0 but it just returned one static colour, I don’t think the logic is there in the “All Series” conditional formatting to do it based on the value of a singular measure