Skip to content

Error on using add_vline with text annotation for data with date-time x axis #3065

Closed

Description

@MR0205

Hi, I am trying to use the library for a simple visualisation for the first time, and I stumbled upon supposedly a bug trying to draw a vertical line with text annotation on a graph with a date-time x axis.

import plotly.express as px
df = px.data.stocks(indexed=True)
fig = px.line(df)
fig.add_vline(x="2018-09-24", annotation_text="test" )
fig.show()

I get the following error message:

TypeError: unsupported operand type(s) for +: 'int' and 'str'

Could anyone please help me confirm that it is indeed a bug, my version is '4.14.1' ? Thank you.

Activity

  1. added this to the upcoming milestone on Feb 5, 2021
  2. nicolaskruchten commented on Feb 5, 2021

    @nicolaskruchten
    Contributor

    Yep, definitely a bug! Thanks for the clear and reproducible report :)

    I'm not immediately clear why we need to compute the midpoint of anything here

    but this is the problem. Ideally we would need to rework this to use the (x|y)anchor attribute instead of trying to do math on the coordinates in the Python layer.

  3. awrobel1 commented on Feb 13, 2021

    @awrobel1

    Hi @MR0205,

    If you're looking for a temporary workaround, you can get the annotation to work by converting your x value into milliseconds since epoch as follows:

    import plotly.express as px
    import datetime
    df = px.data.stocks(indexed=True)
    fig = px.line(df)
    fig.add_vline(x=datetime.datetime.strptime("2018-09-24", "%Y-%m-%d").timestamp() * 1000, annotation_text="test" )
    fig.show()
    
  4. MR0205 commented on Feb 18, 2021

    @MR0205
    Author

    @awrobel1 Thanks for your idea, I thought on using a rectangle as a replacement, where you would make both edges start at the limit of a single day. Not sure though that will completely imitate the vertical line, due to possible problem when zooming.

  5. YukunYangNPF commented on Mar 11, 2021

    @YukunYangNPF

    Following this too!

  6. tomshaffner commented on Jun 2, 2021

    @tomshaffner

    The above suggestion from @awrobel1 was great for me. In my case I simplified a tad with x=datetime.datetime(2021,5,27).timestamp() * 1000. No need to convert from a string first in this case.

  7. nicholas-esterer commented on Aug 2, 2021

    @nicholas-esterer
    Contributor

    Yes, after looking into this a bit more, the implementation assumes the data are types that can have arithmetic performed on them. It needs to do this in order to compute where to put the annotation. This bug probably got through because to compute where an annotation is placed, it only needs to find the minimum, maximum or mean of the extreme coordinate values. min and max are defined for strings, so dates don't break it for positions like 'left', 'right', etc., but I think the fact that it works is just luck: the strings often sort the same as the dates.
    This points to 2 things that could be fixed at the higher level:

    • when doing arithmetic on data, operators should be chosen corresponding to the type of the axis: e.g., if the axis type is 'date' then the values should be converted to milliseconds before arithmetic is performed
    • rather than having anchored annotations only available when using add_hline and the like, maybe have them available when using add_shape? Then add_hline, etc. are just special cases of add_shape.
  8. ClaudiaBehnke86 commented on Jan 5, 2022

    @ClaudiaBehnke86

    Hi all,

    I have a rather weird problem that might be connected to this issue.

    I deployed an app using streamlit (V'1.2.0')

    I use Plotly (V'5.3.1') to create a plot in the app.

    The plot is a timeline, and there is a vertical line in it.
    Based on this bug, i caluclate the postion of the of the line the following:
    end_time_prelim = datetime.strptime(df['end_time'].max(), "%Y-%m-%d %H:%M:%S").timestamp() * 1000

    And then use this in
    fig.add_vline(x=end_time_prelim)
    This works fine when I run the code locally.
    However, in the online version, the line is at a shifted different position and slightly shifted.

    Is this known?
    Thanks a lot :-)

    Not sure if helpful, but this would be the app:
    https://share.streamlit.io/claudiabehnke86/tournamentcalculator/tourcalc/theapp.py

  9. awrobel1 commented on Jan 5, 2022

    @awrobel1

    Hi @ClaudiaBehnke86,

    Not sure, but you might be having trouble with time zones? When you run time timestamp calculation I believe that its looking for the timestamp based on your current timezone. So locally, everything works intuitively, but when you host your code in the cloud you start running on a UTC server and the times all seem to jump.

    If this is the problem you just need to make sure to adjust your line based on the difference between your current time and UTC, by adding/subtracting milliseconds or using timezone aware times.

    Also, make sure your code can handle time shifts for daylight savings time if relevant!

  10. ClaudiaBehnke86 commented on Jan 5, 2022

    @ClaudiaBehnke86

    Yes, this makes a lot of sense :-D. Thanks for the hint!

  11. alexrblohm commented on Mar 24, 2022

    @alexrblohm

    Hi @MR0205,

    If you're looking for a temporary workaround, you can get the annotation to work by converting your x value into milliseconds since epoch as follows:

    import plotly.express as px
    import datetime
    df = px.data.stocks(indexed=True)
    fig = px.line(df)
    fig.add_vline(x=datetime.datetime.strptime("2018-09-24", "%Y-%m-%d").timestamp() * 1000, annotation_text="test" )
    fig.show()
    

    Thanks for this! I had the same issue and it worked for me!

  12. fzyzcjy commented on Jun 15, 2022

    @fzyzcjy

    Hi, how can I do similar things when x are strings (labels) instead of dates or numbers?

  13. mateomontero01 commented on Jul 21, 2022

    @mateomontero01
    Contributor

    This is still a problem for all categorial data on the x axis. Is there any solution for when x are strings?

  14. 6 remaining items

  15. archmoj commented on Feb 23, 2024

    @archmoj
    Contributor

    What happens if you convert the dates to UNIX timestamps?

  16. alexcjohnson commented on Feb 23, 2024

    @alexcjohnson
    Collaborator

    Oh gosh, I don’t think we want to recommend Unix timestamps… we’d need them to be in milliseconds, and quite likely this will give time zone problems due to our weird backward-compatibility hacks on the plotlyjs side

  17. Dario-Mantegazza commented on Feb 23, 2024

    @Dario-Mantegazza

    What happens if you convert the dates to UNIX timestamps?

    I will try to test it on the week of the 11th of March as before I don't have time. I hope I will remember XD

  18. PainOchoco commented on Jun 26, 2024

    @PainOchoco

    Oh gosh, I don’t think we want to recommend Unix timestamps… we’d need them to be in milliseconds, and quite likely this will give time zone problems due to our weird backward-compatibility hacks on the plotlyjs side

    You're right, I've tried changing the datetime to a unix timestamp but the time zone is not kept, resulting in an offset on the vertical lines.
    Please look into this, it's been a bug for 3 years!

  19. rian-dolphin commented on Apr 16, 2025

    @rian-dolphin

    I'm also having the timezone issue mentioned by @PainOchoco here when using the unix workaround. The vertical lines are shifted by an hour. Any planned fix for this?

    I found another workaround that fixes the time zone issue by using add_shape along with add_annotation (if you want an annotation). Example below:

    # dt is of type datetime.datetime
    fig.add_shape(
        type="line",
        x0=dt,
        x1=dt,
        y0=0,
        y1=1,
        yref="paper",
        line=dict(
            color="red",
            width=1,
            dash="dash",
        ),
    )
    fig.add_annotation(
        x=dt,
        y=1,
        yref="paper",
        text="This is an annotation",
        showarrow=False,
        textangle=-90,
        font=dict(size=10),
        xanchor="left",
        yanchor="top",
    )
    
  20. added a commit that references this issue on May 20, 2025
    d03b087
  21. admo1 commented on Aug 14, 2025

    @admo1

    I'm also having the timezone issue, any news on this issue ?

  22. hugoalvarado commented on Aug 22, 2025

    @hugoalvarado

    Another workaround is to use vrect with the same value for x0 and x1 - visually the same as vline.

    ✅

    fig.add_vrect(
                    x0=ny_open.strftime("%Y-%m-%d %H:%M:%S"),
                    x1=ny_open.strftime("%Y-%m-%d %H:%M:%S"),
                    line_width=1,
                    line_dash="dash",
                    line_color="red",
                    layer="below",
                    annotation_text=f"NY open"
                  )

    ❌

    fig.add_vline(
                    x=ny_open.strftime("%Y-%m-%d %H:%M:%S"),
                    line_width=1,
                    line_dash="dash",
                    line_color="red",
                    layer="below",
                    annotation_text=f"NY open"
                  )
  23. added 2 commits that reference this issue on Feb 14, 2026
    8f517d9
    9bed9d3
  24. pbeart commented on Apr 15, 2026

    @pbeart

    The above suggestion from @awrobel1 was great for me. In my case I simplified a tad with x=datetime.datetime(2021,5,27).timestamp() * 1000. No need to convert from a string first in this case.

    Importantly, plotly (very bizarrely) displays dates which are numerical timestamps in local time not UTC like everything else, so doing mydatetime.isoformat() is a bit better

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Labels

P3backlogbugsomething brokensev-2serious problem

Type

No type

Projects

No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions