Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    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
    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's avatar
Gordonlilj
Solution Sage
6 years ago

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

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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!