Forum Discussion
TomJWhite
5 years agoFrequent Visitor
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. ...
- 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
v-janeyg-msft
Community Support
5 years agoHi, 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