Red/Yellow/Green Indicator visual

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.