display project step status with colored indicators

Hi Anonymous 

Look at my test, this is final result.

Create measures

Measure_integrate =
VAR n_in_integrate =
    CALCULATE (
        COUNT ( Table1[integrate] ),
        FILTER (
            ALLEXCEPT ( Table1, Table1[flux], Table1[period] ),
            Table1[integrate] = "n"
        )
    )
RETURN
    IF ( n_in_integrate = BLANK (), 1, 0 )

Measure_standard =
VAR n_in_standard =
    CALCULATE (
        COUNT ( Table1[standard] ),
        FILTER (
            ALLEXCEPT ( Table1, Table1[flux], Table1[period] ),
            Table1[standard] = "n"
        )
    )
RETURN
    IF ( n_in_standard = BLANK (), 1, 0 )

Measure_consistent =
VAR n_in_consistent =
    CALCULATE (
        COUNT ( Table1[consistent] ),
        FILTER (
            ALLEXCEPT ( Table1, Table1[flux], Table1[period] ),
            Table1[consistent] = "n"
        )
    )
RETURN
    IF ( n_in_consistent = BLANK (), 1, 0 )

Measure_balance =
VAR n_in_balance =
    CALCULATE (
        COUNT ( Table1[balance] ),
        FILTER (
            ALLEXCEPT ( Table1, Table1[flux], Table1[period] ),
            Table1[balance] = "n"
        )
    )
RETURN
    IF ( n_in_balance = BLANK (), 1, 0 )

Measure_delivery =
VAR n_in_delivery =
    CALCULATE (
        COUNT ( Table1[delivery] ),
        FILTER (
            ALLEXCEPT ( Table1, Table1[flux], Table1[period] ),
            Table1[delivery] = "null"
        )
    )
RETURN
    IF ( n_in_delivery = BLANK (), 1, 0 )

icon_integrate = unichar(11044)
icon_standard = unichar(11044)
icon_consistent = unichar(11044)
icon_balance = unichar(11044)
icon_delivery = unichar(11044)

then format the each icon with colors

See more details in my file.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft ,

You help me a lot ,thank you very much.