Format based on column values

[notintoexcel11]

Hi All,

PFA the screenshot of my matrix table. I wish to create a separate column highlighting those values for whom the value in "dispatch efficiency %" is below 50% as something (like a symbol or colour or others) , but not in the same column. How can I achieve this?

[Anonymous · Accepted solution]

Hi @notintoexcel11 ,
Thanks for @Ashish_Mathur  and @VahidDM  reply.
The following additions were made:
Sample data:

Create a measure

Measure = 
VAR a = 
CALCULATE(
    MAX('Table'[Column2]),
    FILTER(
        'Table',
        'Table'[Column1] = "P2"
    )
)
RETURN
IF(
    a <> BLANK(),
    IF(
        a < 0.5,
        "Red",
        "Green"
    ),
    "Black"
)

Apply the measure to the font color

Final output

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[VahidDM]

Hi @notintoexcel11 

You need to create a Measure to check the "dispatch efficiency %" value and for example return 1 when it  is below 50% and 0 when it is more than that.

Then add that measure to the matrix as a new column.

Set the conditional formatting based on the value of the measure to add icon and set that condition to only shows icon not value.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[notintoexcel11]

It says unable to load data for this visual.

[Ashish_Mathur]

Hi,

Remove the "" from 50%.  Change 50% to 0.5