Forum Discussion

GuerauFF's avatar
GuerauFF
Helper II
6 years ago

Machine Status depending on time (chronologically)

Hello everybody!

 

I am having issues with a certain visualization and I would really appreciate some help. 

 

I have a dataset where I have the following variables: Machine (as in machine 1, machine 2, machine 3...), State (as in Running, Stopped or Under Maintenance p ex.) and the start and the end date for each state. Here's an image as an example of the data set. 

 

      State                            Machine                       Start Date                    Finish Date

 

What I would like to visualize is the state for each one of the machines for each moment during the day, this way, I can quickly see which machines have been stopped and for how long as well as see if the stoppage of one of the machines results in a stoppage of the machine that follows it down the process. 

 

To sum it up, I would like to represent the data this way:

I've tried to do it with a Gantt Chart but I don't get the result that I want. Also looked in the AppSource but couldn't find anything.

 

Does anyone have any idea how I could manage to solve this problem? I would greatly appreciate it!

 

Thanks in advance, 

 

Guerau

2 Replies

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support

    Hi GuerauFF ,

     

    After my tests, none of the gantt charts in the appsource can show the expected result. You could post your idea here to improve Power BI and make the feature coming sooner.