Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Thank you so much for taking the time to do that! I spent some time on it in the meantime and I have gotten it to a similar looking visual. Do you mind me asking how you inserted those dotted lines to represent the two significant timestamps (8 and 10 years for service life and end of life)? I really like how you did that compared to what I currently have. Is there also a specific way to format the verticallity of the visual (e.i. mine is currently showning 4 quadrants instead of all in one column)?
*edit - now I see that you used two constant lines! Makes a lot more sense now. Still interested in the vertical formatting though!
In the "Small Multiples" you can specify the number of rows and columns.