display project step status with colored indicators

[Anonymous]

Hi,

I want to display each step status of my project with red,green,gray circle.

I have data as below 

My Visual in power BI should be like this:

In my report i have no filter so the dashboard have to display flow of current period (eg:201904) but if i have in the past a failure, i want to show this failure too.

Can you help me to achieve this?

Thank you in advance

[v-juanli-msft · Accepted solution]

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.

[Anonymous]

Hi, 
you can create circles using following code in calculated column as well as in measure.

UNICHAR(11044)

then use font formatting option available in table visual to colour code them as per requirement. 

[Anonymous]

Hi @Gordonlilj 

thank you for your answer;

Do you have an idea to create this measure with considering the period?

As i said, i want to display feed in the current period and those ones that failed in the past.

Thank you

[v-juanli-msft · Accepted solution]

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.

[Anonymous · Accepted solution]

@v-juanli-msft ,

You help me a lot ,thank you very much.

[Gordonlilj]

Hi,

You could create a measure using this code that creates the indicator

measure = unichar(11044)

and than use conditional formatting to change the color based on the fields