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 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

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.

5 Replies

  • Gordonlilj's avatar
    Gordonlilj
    Icon for Solution Sage rankSolution Sage
    7 years ago
    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
  • 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.