Forum Discussion

Turf03's avatar
Turf03
Icon for Helper II rankHelper II
6 years ago
Solved

Identify significant dates on a line chart

Is there a way to insert a line or a call out on specific dates on a line chart. I'd like to point out significant dates.    
Need Help
  • P_D_G's avatar
    P_D_G
    6 years ago

    Hi Turf03 ,

     

    you might wanna try pulse chart which has a similar funcitonality.

    Best,

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
6 years ago

Hi Turf03 ,

 

You may insert Shapes (such as line or Triangle) into the specific location which you want on Axis of chart,  and it is not dynamic as explained. See the attached screenshot.

In addition, you may try to use a combination chart.

  1. Create a "line and stacked column chart"
  2. Put column [Date] into shared axis , and put [values] into line values.
  3. Create a measure that evaluates to the maximum value when Date=specific date(otherwise blank), put this measure into column values.

You may create measure like DAX below:

 

 

Specific Date line =  IF ( VALUES ( Table1[Date] ) = DATE ( 2020, 9, 1 ), MAXX ( ALL ( Table1[Date] ), MAX ( Table1[Sales] ) ))

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.