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