Forum Discussion
Reference line (vertical) to a specific date
Hi all,
I want to insert a vertical reference line to a specific date (e.g. Covid-19 beginning) on a line graph.
I've seen an option whereby you could literally draw such a line but this is not the solution I am looking for.
Does anyone know a solution?
thanks,
L_B
Hi L_B ,
I have a similar sample about it. Actually the vertical line in my sample is a column from Line and stack/clustered column chart. It hights the minium date in my sample. You could refrence it to have a try. Hope it can give you a few ideas.
Measure = var mindate = MINX(ALL('Table'),'Table'[Date]) return IF(SELECTEDVALUE('Table'[Date]) = mindate,1)
4 Replies
- Greg_Deckler
Community Champion
L_B - I have never seen an "automatic" solution for this.
- amitchandak
Super User
L_B , you can not have like. but on combo visual, you can bar. make sure it null on all other dates.
No same example but good idea
v-xuding-msftCommunity Support
Hi L_B ,
I have a similar sample about it. Actually the vertical line in my sample is a column from Line and stack/clustered column chart. It hights the minium date in my sample. You could refrence it to have a try. Hope it can give you a few ideas.
Measure = var mindate = MINX(ALL('Table'),'Table'[Date]) return IF(SELECTEDVALUE('Table'[Date]) = mindate,1)Impressive youtube vid with some coding. It's a workaround, but should work great on a line chart.
