Skip to main content
Microsoft Idea

Power BI

Needs Votes

Vertical reference lines on the x axis

Vote (318) Share
Nikki Csepegi's profile image

Nikki Csepegi on 10 Jun 2017 02:18:25

I plot anomaly trend data over time. I would like the ability to include dynamic vertical reference lines on the date (x axis) for all applicable chart types (line, bar, stacked bar, combination, etc). The reference lines represent milestones and help to explain and understand changes in trend data.

Comments (24)
Nikki Csepegi's profile image Profile Picture

Linda on 06 Jul 2020 00:05:15

RE: Vertical reference lines on the x axis

I would like to use this function to mark special days like Christmas, Easter or Mother's day.

Nikki Csepegi's profile image Profile Picture

Arthur on 06 Jul 2020 00:04:31

RE: Vertical reference lines on the x axis

Maybe it would help to make the implementation easier if in the "Analytics" section of the visual you could change the "Constant" line type based on the axis since we can already do that with the Y-axis but not the X-axis!

Nikki Csepegi's profile image Profile Picture

Power BI User on 06 Jul 2020 00:00:06

RE: Vertical reference lines on the x axis

Seems a useful as well as an easy add - this would have an awful lot of use in date-based analysis, to highlight today's date for the basis of backlogs, some relative date in the past for serious backlogs etc

Nikki Csepegi's profile image Profile Picture

Michael Milirud on 05 Jul 2020 23:38:23

RE: Vertical reference lines on the x axis

Such a low hanging fruit. Definitely a common use case when plotting forecasts or to highlight checkpoints on a trend line.

Nikki Csepegi's profile image Profile Picture

Nate Brunner on 05 Jul 2020 23:37:13

RE: Vertical reference lines on the x axis

I second everyone here...this is much needed for time analysis.

Nikki Csepegi's profile image Profile Picture

Eric Thomas on 05 Jul 2020 23:33:12

RE: Vertical reference lines on the x axis

This is critical and a basic functionality of all timelines. Please develop this.

Nikki Csepegi's profile image Profile Picture

Power BI User on 05 Jul 2020 23:31:58

RE: Vertical reference lines on the x axis

I can't agree more xD

Nikki Csepegi's profile image Profile Picture

Neil MacMullen on 05 Jul 2020 23:31:56

RE: Vertical reference lines on the x axis

Incredible this isn't supported, especially as any chart with a DateTime x axis fails to show any vertical gridlines indicating where each 24 hour period starts/stops.

Nikki Csepegi's profile image Profile Picture

Rolando on 05 Jul 2020 23:30:15

RE: Vertical reference lines on the x axis

is really usefull for events, please :)

Nikki Csepegi's profile image Profile Picture

Martin Mason on 05 Jul 2020 23:19:46

RE: Vertical reference lines on the x axis

On a date based horizontal axis I would like to add a vertical line that is 'today's date'