Can not use measure by formatting background

[lucacebraak]

Hi everyone, 

I would like to use the formatting tool for the background of my table. But it seems that I can not use the measure for this. 

my measure: 

I can not select 'Difference_DD_ALL2',  why? 

Can someone help me out? 

thanks in advance. 

Kind regards, 

Luca 

[Anonymous · Accepted solution]

Hi @lucacebraak ，

Why can't you select the measureDifference_DD_ALL2 ? That's because the return value is a Text type (it uses the FORMAT function). You can base the formatting on the current field, or on any field in your model that has numerical or color data.

You can refer the following links to use conditional formatting for table/matrix visuals.

Use conditional formatting in tables

Power BI Conditional Formatting for Matrix and Table Visuals

Best Regards

[amitchandak]

@lucacebraak , If you using field value then measure should return text - color

example 

Color Category = SWITCH(Max('Item'[Category]) ,
"Category 1" , "Blue",
"Category 2" , "Green",
"Category 3" , "Gray",
"Category 4" , "Yellow",
"Category 5" , "Silver"
)

Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) <today(),"lightgreen","red")

In case rule base , measure should be number. Format might be making is as text