Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

display project step status with colored indicators

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 ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

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

    v-juanli-msft ,

    You help me a lot ,thank you very much.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

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's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

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

      v-juanli-msft ,

      You help me a lot ,thank you very much.