Conditional Formatting a Text Measure in a Matrix

[GuillemXII]

Hi everyone, 

I've been trying to apply a conditional format to a calculated measure with text values but without success:

I would like that in the last column ("Nivel Entrevista") depending on the text, the background color changed as following: 

"Nivel 1": Green 
"Nivel 2": Yellow (it says "Yellow", and no, is not just you who doesn't manage to read it )
"Nivel 3": Orange
"Nivel 4": Red

BLANK: regular format

Any help will be much appreciated!

Thank you all!

[v-juanli-msft]

Hi @GuillemXII 

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[GuillemXII]

Sorry @v-juanli-msft for not answering earlier. 

Yes, it's been solved now!

Thank you both!

[v-juanli-msft · Accepted solution]

Hi @GuillemXII 

Don't use "EVALUATE" or "DEFINE" in the formula.

You may click "new table" by mistake.

Please use the formula as Gordonlilj provided in the "New column".

If you need a measure,

Create a measure

(assume 'Table'[Nivel] is a measure too, if not, replace with  Max('Table'[Nivel])

Calc measure= 
Switch(TRUE(),
        'Table'[Nivel] ="Nivel 4",4,
        'Table'[Nivel] ="Nivel 3",3,
        'Table'[Nivel] ="Nivel 2",2,
        'Table'[Nivel] ="Nivel 1",1
)

Then use the measure to configure color conditionally.

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Gordonlilj]

Hi,

One thing you could try is first creating a calculated column using something like this

CalcColumn= 
Switch(TRUE(),
        'Table'[Nivel] ="Nivel 4",4,
        'Table'[Nivel] ="Nivel 3",3,
        'Table'[Nivel] ="Nivel 2",2,
        'Table'[Nivel] ="Nivel 1",1
)

Then you could set up conditional formatting like this and it should work

[GuillemXII]

Hi @Gordonlilj , 

I've tried to apply your method but it's telling me that "the expression specified in the query is not a valid table expression"...

Any other idea?

Thank you anyway!