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

     

     

VahidDM's avatar
VahidDM
Super User
2 years ago

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's avatar
    notintoexcel11
    Frequent Visitor
    2 years ago

    It says unable to load data for this visual.

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      2 years ago

      Hi,

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