Adding Markers to Chart

[datapal04]

Hello,

I have a bar chart that counts the number of cases our business unit receives. As an aside, we also have different Events (at any random day) which may influence the number of cases received. I'd like to have a marker (or some visual) to quickly identify when an Event occured. How would you suggest to go about this? Desired outcome is below (Event markers are in orange).

Thanks in advance for your help!

[rsbin · Accepted solution]

@datapal04 ,

My suggestion is to use the Combo Clustered Line Chart.  This can be a 1 or 0 or actual Event Count.

Create a measure to Count your Events.  Put this as your Line.  Something like this.

Then you can change line stroke width to 0, and change the Marker per your requirement.

Hope this gives you an idea to work with.

Regards,

[datapal04]

Thank you! I'm curious if there is a mehod to display the name of the event when a user hovers over a marker?

[rsbin]

@datapal04 ,

Yes, you can use the Tooltip functionality.

Drag the field or fields you want to display into the Tooltip well.

Other option is to create a custom Tooltip Page.   Search Youtube and you will get all the info you need and much better explanation than I can do here.

Regards,

[Arul]

@datapal04 ,
To achieve this you have to use line and stacked column chart and then in the Line y  axis you have to use event metrics, then you have to enable markers under marker section then reduce the line stroke under line properties.
Now you may get the expects result.

Thanks,

[Arul]

@datapal04 ,

Please share sample data.

Thanks,

[datapal04]

Here you go. There 2 tables: cases by day and dates for Events.

Date	Case Numbers	DayType
2022-06-13 0:00	180	Weekday
2022-06-14 0:00	252	Weekday
2022-06-15 0:00	269	Weekday
2022-06-16 0:00	244	Weekday
2022-06-17 0:00	269	Weekday
2022-06-18 0:00	129	Weekend
2022-06-19 0:00	96	Weekend

eventname	eventdate
Event 1	2022-06-14
Event 2	2022-10-19

[Arul]

@datapal04 ,

try this,

then,

make line stroke to 0

Thanks,