Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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
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.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |