Forum Discussion

notintoexcel11's avatar
notintoexcel11
Frequent Visitor
2 years ago
Solved

Format based on column values

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 o...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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