Red/Yellow/Green Indicator visual

[jenmar2023]

Hi, I have a matrix visual and what I'm trying to display is only one indicator for each state BUT if a state has more than 1 color then the color that needs to appear is in this order (R, Y, then G).  So for AK it needs to display R, AL = Y, AR = R and AZ = R

     G          R           Y

AK 1          1

AL 1                       1

AR             1

AZ             1           1

....

Any suggestions? Thank you

[Anonymous · Accepted solution]

Hi @jenmar2023 ,

I have created a simple sample, please refer to my pbix file to see if it helps you.

Create 2 measures.

Measure =
SWITCH (
    TRUE (),
    MAX ( 'Table'[color] ) = "R", 1,
    MAX ( 'Table'[color] ) = "Y", 2,
    MAX ( 'Table'[color] ) = "G", 3,
    BLANK ()
)

Color Measure =
VAR _MIN =
    MINX (
        FILTER ( ALL ( 'Table' ), 'Table'[item] = SELECTEDVALUE ( 'Table'[item] ) ),
        [Measure]
    )
RETURN
    SWITCH (
        TRUE (),
        _MIN = 1, "Red",
        _MIN = 2, "Yellow",
        _MIN = 3, "Green",
        BLANK ()
    )

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[jenmar2023]

OR is there a way to create a column that says if there's a Red, then Red
or if Red doesn't exist, the next one is Yellow, otherwise Green