Overlapping Bar Chart Visual Recommendation

[mmaguire201]

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.

[v-jianpeng-msft · Accepted solution]

Hi, @mmaguire201 

Depending on your description and the data you're given, you might need a few visuals:

1.Bullet chart:

You can click the Download sample button next to it to download the sample PBIX provided by these visuals to see how they can be used:

You can learn to use this visual by clicking the link below:

Power BI Custom Visuals - Bullet Chart - YouTube

2.Acterys Variance

You can click the link below to learn how to get those published visuals:

Import Power BI visuals from AppSource or from a file - Power BI | Microsoft Learn

You can also browse other visuals in the visual store. We hope you find the above advice helpful.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.