Add a Linear line from top left to bottom right in Line Chart

[KarenFingerhut]

Hi there

Can somsone please help with the below 

I'm trying to add a line in to a line chart where basically shows the max starting position and the end position in a straight line. I have added a screenshot below and drawn the line in. I have tried using the in-built funactionalities of formating the chart  but I can't seem to find anything that will work.

Can someone please help

Thank you

Karen

[MFelix · Accepted solution]

Hi @KarenFingerhut 

For this add a new measure with the following syntax:

Max min line =
IF (
    MAX ( 'Table'[Date] ) = MAXX ( ALL ( 'Table'[Date] ), 'Table'[Date] )
        || MIN ( 'Table'[Date] ) = MINX ( ALL ( 'Table'[Date] ), 'Table'[Date] ),
    SUM ( 'Table'[Value] )
)

Then add this as a secondary measure on your chart

[MFelix · Accepted solution]

Hi @KarenFingerhut 

For this add a new measure with the following syntax:

Max min line =
IF (
    MAX ( 'Table'[Date] ) = MAXX ( ALL ( 'Table'[Date] ), 'Table'[Date] )
        || MIN ( 'Table'[Date] ) = MINX ( ALL ( 'Table'[Date] ), 'Table'[Date] ),
    SUM ( 'Table'[Value] )
)

Then add this as a secondary measure on your chart

[KarenFingerhut]

HI @MFelix 

Thanks very much for getting back to me. It works brilliantly but as soon as I start filtering on dates it stops working. Eaxmples below.

Before changing date range 

After date range change. You can see I just get a dot on the far right

Can you please advise if this is possible to fix, so its interactive with whatever date range you select

Appreciate all your help

Kind regards

Karen

[MFelix · Accepted solution]

Hi @KarenFingerhut

Replace the ALL on the measure by ALLSELECTED everything else keep as is. 

[KarenFingerhut]

HI @MFelix 

Brilliant that worked a treat. I did try ALLSELECTED but I had the date in this format 

Changes[opened_at_value].[Date]  instead of this Changes[opened_at_value] , which then worked after I received your advice.

Thanks for all your help 🙂

Have a great day

Kind regards

Karen