Forum Discussion

Rostanga's avatar
Rostanga
Frequent Visitor
2 years ago

Color formatting a cell with zero value in a decomposition tree visual

I have a decomposition tree set up and have conditional formatting on the values so they turn either red or green if one of the columns is yes or no.   Then i have a count of people in another colu...
Need Help
parry2k's avatar
parry2k
Super User
2 years ago

Rostanga try this:

 

Colour Code Measure =
IF (
    [Measure] = 0,
    "Red",
    (
        SWITCH (
            TRUE (),
            SELECTEDVALUE ( 'datasource'[Yes/No] ) = "Yes", "Green",
            SELECTEDVALUE ( 'datasource'[Yes/No] ) <> "Yes", "Red"
        )
    )
)
Rostanga's avatar
Rostanga
Frequent Visitor
2 years ago

Unfortunately still staying grey.