Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

font color field formating

Hello,    I would like to use font field formating based on the variable run_Status. This variable take the value of 0 for failed, 1 for Succeeded and 3 for Cancelled. I have created a variable n...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

You need to create a measure like the following DAX:

color measure =
VAR a =
    SELECTEDVALUE ( 'TestTable'[run_Status] )
RETURN
    SWITCH ( a, 1, "green", 0, "red", 3, "yellow" )

Then add the measure to color formating.

You could use the type of color like "#000000".

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Good Morning,

 

I have test your solution and it works partially.  It is hard to understand the behavior of the conditional formatting.

Some Status run with a value of Succedeed are colored in green but not all.  The Cancelled run status should be orange and the failed one red.  None of those are colored.

 

In my dashboard, I have a Day slicer which permit me to select one day or multiple days (maximum last 7 days) and another slicer to select the run status(Cancelled, Failed, Succeeded).  It could be that.

 

Is it possible to modify the dax to obtain the run status field to be colored by it's value?

 

Thank in advance for your help.