Forum Discussion
Anonymous
6 years agoNot applicable
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") depe...
- 6 years ago
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.
v-juanli-msft
6 years agoCommunity Support
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
Anonymous
6 years agoNot applicable