Dynamic vertical line in line chart

[MSAYED26]

Hello,I want to add a dynamic vertical line by action date in line chart

Action Date

01-10-2022

01-02-2023

[MFelix]

Hi  @MSAYED26, 

Not sure how you want this to be dynamic but looking at the information you provide you need to add two new measure to your model:

Min Action date = MIN(ActionDates[Action Date])

Max Action date = MAX(ActionDates[Action Date])

Now on the option of the line visual add two reference lines with the X-Axis Constant line, one with each of the measure created previously:

[MSAYED26]

Thanks i know the problem and it work,But if i have more than 2 action date how can add it.

[Anonymous]

Hi @MFelix ,Thanks for your quick reply, I will add more.

Hi @MSAYED26 ,

If you have multiple dates, you need to create multiple measures.

The Table data is shown below:

Use the following DAX expression to create a column

Rank = RANKX('Table 2',[Action Date],,ASC,Dense)

Use the following DAX expression to create measures

Measure = MAXX(FILTER('Table 2',[Rank] = 1),[Action Date])

Measure 2 = MAXX(FILTER('Table 2',[Rank] = 2),[Action Date])

Measure 3 = MAXX(FILTER('Table 2',[Rank] = 3),[Action Date])

Final output

Best Regards,
Wenbin Zhou
If this post helps, please mark @MFelix  as the solution.

[MSAYED26]

Thanks for reply,but can you find other way , because i have more than 20 action date

[MSAYED26]

Thanks, but i dont have reference lines