Forum Discussion
Conditional Formatting a Text Measure in a Matrix
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 :smileylol:)
"Nivel 3": Orange
"Nivel 4": Red
BLANK: regular format
Any help will be much appreciated!
Thank you all!
Hi Anonymous
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
MaggieCommunity 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.
5 Replies
Hi Anonymous
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
MaggieCommunity 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.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
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!
Hi Anonymous
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
