Status Graph in PowerBI

[Anonymous]

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.

[Anonymous]

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!

[amitchandak]

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

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