Visual production line start and stop cycle help

[M-M-P]

Hi

I am trying to make the visual you can see below (made in photoshop) or something similar to it.
It shows when a production line is running or are stopped, every hour at 5 minute intervals.

I could really use some input on how to structure the data and how to build the visual itself in Power BI.

I have been working with horizontal stacked bar chart and vertical stacked column chart. But has not made anything work yet.

Thanks in advance

[M-M-P]

Hi @amitchandak @Jihwan_Kim 

Thank you both. It was just the idea I needed.

[Jihwan_Kim]

Hi, @M-M-P 

Please check the below picture whether it is suitable for your case.

It can be created by using Matrix visualization with conditional formatting.

The sample pbix file's link is down below.

https://www.dropbox.com/s/kxawhvd9vzu901h/mmp.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[amitchandak · Accepted solution]

@M-M-P , Matrix visual. Color-based on the value of status. An hour on row. Minute on column

max(status) in values 

Create a color measure like this and use that in conditional formatting of both background and color

Switch (max(status),

"Running", "green",

"Stopped", "red",

"blue"

)

refer for steps : https://youtu.be/RqBb5eBf_I4