Forum Discussion
Conditional Formatting - measures not available
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?
4 Replies
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.
CheersWhen 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 :smileyhappy:
Hi Anonymous
Here is the document for your reference.
Regards,
Cherie
