How to Display Maintenance Events on a Production Profile Line Chart in Power BI Hello every

[neeesz780]

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:

1. Production Table (continuous data)

   • Date (monthly records)
   • Water rate per month
   • Well ID

2. 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 ?

[Deku · Accepted solution]

https://github.com/EvaluationContext/Forum-Answers/blob/main/water%20rate.pbix

[Deku]

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

[Deku · Accepted solution]

https://github.com/EvaluationContext/Forum-Answers/blob/main/water%20rate.pbix

[neeesz780]

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?  

[Deku · Accepted solution]

Add a dimension for wells. And change the acidental 1:1 date->maintance with 1:many

Wells = DISTINCT( Production[WELL_Name] )

[neeesz780]

@Deku  Thanks a lot ...its working perfectly now ...all the best 

[Greg_Deckler]

@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.

[neeesz780]

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