Forum Discussion

naitiksoni's avatar
naitiksoni
Regular Visitor
9 years ago
Solved

Reference Line on x-axis

I have date on my x-axis of a Line chart.

I need a vertical reference line on a particular (dynamic) date to see if my trend line crossed that date or not.

 

Thanks.

  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    Hi naitiksoni

     

    To draw the Vertical reference line is currently not possible. You can use bit of trick though. Use Shapes to create a static vertical line and it is not dynamic as explained. See the attached screenshot.

     

  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    Hi naitiksoni,

     

    A vertical reference line is not available now. To work around this requirement, you can 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.

    Measures can be:

    Reference line =
    IF (
        HASONEVALUE ( Table1[Date] ),
        IF (
            VALUES ( Table1[Date] ) = DATE ( 2016, 3, 1 ),
            MAXX ( ALL ( Table1[Date] ), MAX ( Table1[Sales] ) )
        )
    )

     

    Thanks,
    Yuliana Gu

16 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi naitiksoni,

     

    A vertical reference line is not available now. To work around this requirement, you can 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.

    Measures can be:

    Reference line =
    IF (
        HASONEVALUE ( Table1[Date] ),
        IF (
            VALUES ( Table1[Date] ) = DATE ( 2016, 3, 1 ),
            MAXX ( ALL ( Table1[Date] ), MAX ( Table1[Sales] ) )
        )
    )

     

    Thanks,
    Yuliana Gu

    • pschommer's avatar
      pschommer
      Icon for Helper II rankHelper II
      9 years ago

      Thank you for providing this helpful solution to a similar problem I've had!

      I implelemented it and it works as expected. Your screen shot, however, shows a very thin line (which I like) while mine is quite thick. I can't seem to find any formatting option that controls the width of the column(s).

       

      Am I missing something? Can you please point me to this option?

      • Sha_Kri's avatar
        Sha_Kri
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        pschommer, have you figured out how to make that separation column thinner?

  • BhaveshPatel's avatar
    BhaveshPatel
    Icon for Super User rankSuper User
    9 years ago

    Hi naitiksoni

     

    To draw the Vertical reference line is currently not possible. You can use bit of trick though. Use Shapes to create a static vertical line and it is not dynamic as explained. See the attached screenshot.