Forum Discussion

neeesz780's avatar
neeesz780
Regular Visitor
1 year ago
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 ...
Need Help
Deku's avatar
Deku
Super User
1 year ago

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

    • neeesz780's avatar
      neeesz780
      Regular Visitor
      1 year ago

      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's avatar
        Deku
        Super User
        1 year ago

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

         

        Wells = DISTINCT( Production[WELL_Name] )