I'm really looking to create something like this in PowerBI. This is a manual visual that I made in PowerPoint to get my vision "down on paper" so that I could show it to others. This is basically the lifecycle of parts on a well. In this case, there are six wells within the station (I'm creating a maintenance dashboard). Each bar represents a part on the well (pump, motor, shaft) and the exclamation and flag icons represent the "end of service life" and "end of life". The whole point of this visual is to show the current age of the parts with respect to the EOS and EOL. The only way I can think to do this is to utilize the new "overlapping" bar chart feature that was added recently. However, the overlapping only seems to apply to a few of the bars. Not sure what the issue is. If there are other recommendations as to what to do, I am welcoming other ideas.
This is sample data that would apply to this visual:
| Station No | Well ID | Pump Age | Motor Age | Shaft Age | End of Service Life | End of Life Age |
| 1 | W1-1 | 2 | 10 | 9 | 8 | 10 |
| 1 | W1-2 | 4 | 3 | 4 | 8 | 10 |
| 1 | W1-3 | 3 | 10 | 5 | 8 | 10 |
| 1 | W1-4 | 4 | 10 | 7 | 8 | 10 |
| 1 | W1-5 | 3 | 6 | 9 | 8 | 10 |
| 1 | W1-6 | 2 | 5 | 3 | 8 | 10 |
In reality, this dataset will be bigger and will include the wells within other stations. (this visual includes station 1 only). I intend to use a slicer to sort the wells by Station No.
That's pretty ambitious. Here's a simplified version that is not as fancy but will be easier to maintain.
