My measure is not changing the background based on the condition.

[Anonymous]

Hi All,

I have created a measure

 

This is my measure for color scale.

I am using conditional formatting for background colour but its not changing,.

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may create a measure like below.

Result = 
var _status = 
MAXX(
    'Table',
    'Table'[Status]
)
return
SWITCH(
    _status,
    "Completed a","#0000FF",
    "Not Completed b","#008000",
    "Completed c","#FFFF00",
    "Not Completed d","#FF0000",
    "Completed e","#DCDCDC",
    "Not Completed f","#778899"
)

Then you need to set the color format for the card visual as below.

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , is it selectedvalue or the first measure which going to return complete?

Try the formula with the first measure.

if([Auto & ISO ..] = "Complete" ............... )

Also try to use Switch(True() ..

example

Switch(True(),

<Condition>, <result>,

<Condition>, <result>,

<Condition>, <result>,

/// Add more

,<Else result>

)

[Anonymous]

@amitchandak ,

Thanks for your rpl,

I have so many measures in similar way and the values inside the measre changes as the end user selects the Dates from the slicer.

It should look like this 

[amitchandak]

@Anonymous , the formula seems correct. Can you share sample pbix after removing sensitive data.

[Anonymous]

@amitchandak 

Please do let me know how to share the sample file .

[amitchandak]

@Anonymous , you can upload on google drive or one drive and share the link

[Anonymous]

@amitchandak 

Here is the link https://drive.google.com/file/d/1L1njRGrrZdTMDydw2l9N7Cjz6KGuwo27/view?usp=sharing