Conditional Formatting - measures not available

[Anonymous]

I want to color brands based on Profit by Year.

ProfitLastYear = 
var NumbDays = 
    if(
        TODAY() - FIRSTNONBLANK(Verkoopslijnen[Datum], 1) <= 365
        , TODAY() - FIRSTNONBLANK(Verkoopslijnen[Datum], 1)
        , 365
    )

RETURN
   DIVIDE(
        CALCULATE(
            SUM(Verkoopslijnen[Winst])
            , Kalender[Date] >= TODAY() - NumbDays
        )
        , NumbDays
   )

Second Measure is:

ColorPicker = 
SWITCH(
    TRUE()
    , [ProfitLastYear] < 5, "#00FF00"
    , [ProfitLastYear] < 100, "#FFFF00"
    , [ProfitLastYear] <10000, "#FF0000"
    , "#C0C0C0"
)

Now, I want to use the ColorPicker as conditional Format on my brands, but I cannot click on the measures

What Am I doing wrong?

[Aleuzzi]

Hi,

I had the same issue, and I solved it by changing the measure Data type as Text.

Select the color measure, go to Modeling -> Formatting -> Data Type -> Text and try againg the conditional formatting by field.

Cheers

[v-cherch-msft]

Hi @Anonymous

Here is the document for your reference.

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-formatting-by-field-value

Regards,

Cherie

[Sean]

When you open the conditional formatting window in the 

Format By you need to select Field Value

then you should be able to select your Measure in Based on Field 

[Anonymous]

Sean, I know, but it's still impossible to click on the measure :