Hello all,
Just a quick one, I'm looking to try to plot a unique data point according to an x-axis or y-axis and then label it. A hypothetical example would be, I'd like to show a timeline of ticket sales with a marker showing when further COVID restrictions were announced, for example: 1 July-- COVID Restrictions announced. If the timeline was something like Perf Date, can anyone suggest an approach to try to achieve this?
Another example might be like "breakeven point" for ticket sales or something along those lines.
Grateful for any advice from any of you experts out there!
Jenna
Hi Jenna,
I typically do this with a dedicated value that turns the axis date into a number and then compares that to a hard-coded number representing the desired annotation date. E.g.
IF ( MAX( [Calendar Year]*10000 + [Calendar Month]*100 + [Calendar Day Of Month] ) = 20210722 , RSUM ( [Total Ticket Count] ) , NULL )
Then rename the value to "1 July-- COVID Restrictions announced". You can replace the RSUM( [Total Ticket Count] ) with any other value, and can change the chart type for just this value to a column, or whatever changes help make the label visible and distinguished from the primary value, without being overly invasive visually.
Chris, that is genuinely brilliant.
I second the motion for declaration of brilliance!
Thirded. I'm good with Y-Axis (like adding a sales target using a bucket), X axis stuff is tricky. I usually export into Photoshop.