Forum Discussion
How to Display Maintenance Events on a Production Profile Line Chart in Power BI Hello every
| well ID | Date (month) | Intervention Key |
| A1 | 12-2-2022 | AH-L |
| A2 | 15-1-2023 | WL |
| A1 | 5-4-2022 | KT |
| A1 | 15-8-2022 | WL |
| A2 | 15-2-2023 | DHSV |
| A2 | 10-7-2023 | KT-L |
| A1 | 01-01-2023 | WL |
Hello everyone,
I need help visualizing maintenance events on my production profile chart in Power BI.
I have two tables:
Production Table (continuous data)
- Date (monthly records)
- Water rate per month
- Well ID
Maintenance Table (non-continuous data)
- Well ID
- Date of maintenance
- Maintenance code
I would like to:
- Overlay maintenance events as markers or flags on the production profile line chart.
- Enable dynamic tooltips when hovering over a maintenance event to show production data before and after the maintenance.
Is there an easy way to achieve this in Power BI? Any suggestions or best practices would be greatly appreciated!
Thanks in advance
**I've provided sample data for the maintenance table above & sample production data below **
| WELL_Name | Date | Water Rate |
| A1 | 01/01/2022 | 6410.55 |
| A1 | 01/02/2022 | 4763.06 |
| A1 | 01/03/2022 | 1886.78 |
| A1 | 01/04/2022 | 4982.87 |
| A1 | 01/05/2022 | 3513.59 |
| A1 | 01/06/2022 | 4625.7 |
| A1 | 01/07/2022 | 5682.58 |
| A1 | 01/08/2022 | 6426.62 |
| A1 | 01/09/2022 | 1369.74 |
| A1 | 01/10/2022 | 2662.49 |
| A1 | 01/11/2022 | 3323.58 |
| A1 | 01/12/2022 | 3468.75 |
| A1 | 01/01/2023 | 5476 |
| A1 | 01/02/2023 | 2632.59 |
| A1 | 01/03/2023 | 5823.45 |
| A1 | 01/04/2023 | 1064.18 |
| A1 | 01/05/2023 | 4437.96 |
| A1 | 01/06/2023 | 4025.36 |
| A1 | 01/07/2023 | 5971.96 |
| A1 | 01/08/2023 | 6067.46 |
| A1 | 01/09/2023 | 1257.81 |
| A1 | 01/10/2023 | 1874.9 |
| A1 | 01/11/2023 | 7344.33 |
| A1 | 01/12/2023 | 3023.12 |
| A2 | 01/01/2022 | 3513.59 |
| A2 | 01/02/2022 | 3364.77 |
| A2 | 01/03/2022 | 1495.19 |
| A2 | 01/04/2022 | 6674.6 |
| A2 | 01/05/2022 | 4238.58 |
| A2 | 01/06/2022 | 3225.12 |
| A2 | 01/07/2022 | 1300.68 |
| A2 | 01/08/2022 | 3998.92 |
| A2 | 01/09/2022 | 1118.96 |
| A2 | 01/10/2022 | 5921.35 |
| A2 | 01/11/2022 | 5052.11 |
| A2 | 01/12/2022 | 2643.31 |
| A2 | 01/01/2023 | 3327.48 |
| A2 | 01/02/2023 | 6386.45 |
| A2 | 01/03/2023 | 6116.75 |
| A2 | 01/04/2023 | 3931.94 |
| A2 | 01/05/2023 | 7606.3 |
| A2 | 01/06/2023 | 3931.94 |
| A2 | 01/07/2023 | 3886.92 |
| A2 | 01/08/2023 | 6913.59 |
| A2 | 01/09/2023 | 2602.6 |
| A2 | 01/10/2023 | 3322.71 |
| A2 | 01/11/2023 | 2828.76 |
| A2 | 01/12/2023 | 1902.28 |
End result,
1- display production profile as a line and marker only to display if maintenance even took place on that month
2- when hoovering over marker or intervention even to display its code and production value before that date and post that date as tooltip ?
Add a dimension for wells. And change the acidental 1:1 date->maintance with 1:many
Wells = DISTINCT( Production[WELL_Name] )
7 Replies
neeesz780 Sounds very possible. But, without sample data to mockup a solution, kind of difficult to be more specific than that.
Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Good day Greg_Deckler , I've updated details with sample data for both tables and expected result ....what is more important is to flag these events on my production profile in any way possible - ideally as a marker
Appreciate your help
Firstly made sure you have date dimension hooked up to the two tables.
Then add a measure with a constant value
RefLine =
calculate(
max( production[water rate],
Removefilters( dates )
)
Add the line, and make it invisible.
You could could use custom data labels with a measure like below to show a icon when there was maintenance
If( not isempty( maintenance ), "🔧")
You can just use the date dimension as the drillthrough for the custom tooltip
Hi Deku, thanks for your help it worked perfectly fine but what I noticed is that maintenance events are duplicated on the graph for both wells A1 , A2 ? you can't filter using wells
Any idea why?
