Forum Discussion

MSAYED26's avatar
MSAYED26
Icon for Helper II rankHelper II
2 years ago

Dynamic vertical line in line chart

Hello,I want to add a dynamic vertical line by action date in line chart Action Date 01-10-2022 01-02-2023  
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
2 years ago

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's avatar
    MSAYED26
    Icon for Helper II rankHelper II
    2 years ago

    Thanks, but i dont have reference lines

     

  • MSAYED26's avatar
    MSAYED26
    Icon for Helper II rankHelper II
    2 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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's avatar
        MSAYED26
        Icon for Helper II rankHelper II
        2 years ago

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