Reference line (vertical) to a specific date

[L_B]

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

[LloydDobler]

Impressive youtube vid with some coding.  It's a workaround, but should work great on a line chart.

https://www.youtube.com/watch?v=XKmTknbusnY

[v-xuding-msft · Accepted solution]

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)

[amitchandak]

@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

https://community.powerbi.com/t5/Community-Blog/Display-Label-Only-on-the-Last-Data-Point-of-the-Lin...

[Greg_Deckler]

@L_B - I have never seen an "automatic" solution for this.