Forum Discussion
Solved
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 ...
Add a dimension for wells. And change the acidental 1:1 date->maintance with 1:many
Wells = DISTINCT( Production[WELL_Name] )
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?
