Forum Discussion

TomJWhite's avatar
TomJWhite
Frequent Visitor
5 years ago
Solved

Mark key dates in area chart

Hello there   I have a set of data which contains viewing activity for a Netflix account and im wanting to chart that with markers indicating key dates in 2020 regarding lockdowns where I am.    ...
  • v-janeyg-msft's avatar
    5 years ago

    Hi, TomJWhite 

     

    You can create a column and use it in legend, and note that It’s best not to have the same name, or it will connect.

    Like this:

     

    Main Date = 
    SWITCH (
        TRUE (),
        'Table'[Date] = DATE ( 2021, 3, 23 ), "First Lockdown begins",
        'Table'[Date] = DATE ( 2021, 5, 13 ), "Move to Level 2",
        'Table'[Date] = DATE ( 2021, 6, 9 ), "Move to Level 1",
        'Table'[Date] = DATE ( 2021, 8, 30 ), "Move to Level 2 again",
        'Table'[Date] = DATE ( 2021, 8, 12 ), "Second Lockdown begins",
        " "
    )

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.


    Best Regards,

    Community Support Team _ Janey