Forum Discussion

jenmar2023's avatar
jenmar2023
Helper I
2 years ago
Solved

Red/Yellow/Green Indicator visual

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's avatar
    Anonymous
    2 years ago

    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.

     

     

     

     

2 Replies

  • jenmar2023's avatar
    jenmar2023
    Helper I
    2 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.