Column visual w/ date axis, need an "event line" to indicate when change should be seen in the data

[Anonymous]

I would like to add a line at 2020Q3 to indicate when an event (work from home!) occurred.  Any ideas?

Thanks in advance

[amitchandak · Accepted solution]

@Anonymous , I doubt vertical line. you can add a line as a marker.

A bit of logic change in

https://community.powerbi.com/t5/Community-Blog/Display-Label-Only-on-the-Last-Data-Point-of-the-Line-Visual-for/ba-p/1253464

[qrasooli]

Go to Analytics portion of Visualizations Pane. 

Add X-Axis Constant Line, Rename the line to event you want to represent, pick the colors and pick the date you want to show it on and Walla, you have a verticle line showing the event on your visual. Worked perfectly for me!

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

You can add a line as a constant value or max/min/average/median value of the column values in the Power BI column chart, just go to the “Analytics” panel of the chart, like this:

What’s more, you can also check if the Combo chart in Power BI can meet your requirement, please refer to this document:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I was looking for a vertical line or marker (date related) rather than horizontal (value related.)  But thank you; I did find a work-around 🙂

[qrasooli]

what was the work around?

[amitchandak · Accepted solution]

@Anonymous , I doubt vertical line. you can add a line as a marker.

A bit of logic change in

https://community.powerbi.com/t5/Community-Blog/Display-Label-Only-on-the-Last-Data-Point-of-the-Line-Visual-for/ba-p/1253464