Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Status Graph in PowerBI

Hi Experts,

 

The Sample shows a Call center Agent's state change during the day. 

Looking at the data, I used to fill the excel sheet manually shown in the sample each day to understand the agent behavior and to get some other KPI Stats as well.

So, is there a possibility to do it in PowerBI reporting?

 

 

If any expert can guide me on how to do that in Power BI, it would be a great help for me.

 

Thank You.

Best Regards,

Mangala.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , You will get value in all rows. You can use matrix visual

    Assume status column giving you status , let have measure st = max(Table[Status])

     

    Try a color measure, use that in conditional formatting using field value option

    Switch(True() ,

    [ST] = "Ready", "Blue",

    [ST] = "On Call", "Green",

    [ST] = "Office Task", "Yellow",

    "Grey"

    )

     

    How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Amith,

       

      Thanks for your solution. I was able to complete my task upto some stages but the solution doesn't fill the rows until the next state as shown. Is there a way that you can help with that pls?

       

      Thank you.

      Mangala

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Unfortunately, you need to edit some measures or tables to achieve something like this.

    We need a continuous state as a condition for judging the format.

    If this doesn't work for you, please consider sharing more details about it. And it would be great if there was a sample file without any sensitive information here.

     

    Best Regards,
    Community Support Team_Gao


    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!