Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Mark_Berry
Helper I
Helper I

Create markers on a line chart on Power BI

Hello everyone.

 

I am tracking progrees for a project and would like to be able to create an indicator in my line charts for when a significant event or milestones occured or a target is approaching.
For example one chart is tracking traffic flow and I wish to be able to add an arrow or similar and descriptor stating when a major event occured rather than rely on tooltips. I also don't wish to insert arrows and text boxes as I have slicers in use. 

Is there a way to do this? 
I have an image below for reference, the arrows were shapes inserted and did have titles  however I have removed them.

Mark_Berry_0-1692776801395.png

 

1 ACCEPTED SOLUTION
JoeBarry
Solution Sage
Solution Sage

Hi @Mark_Berry 

 

How is your Dataset set up? Is the visual above over time?

 

Are you using a star schema? If you are and you are using the Data from your date table for the time reference in the visual, you could create a seperate table for the Events of Milestones. 

DateTypeTypeIDDescription
11.01.2022Event1Car Crash
11.02.2023Milestone2No Traffic
05.08.2022Milestone2Car Launched

 

Create a one to many relationship between the date in your date table and the date in the new table. Create a Line and Bar chart, the data you have already goes into the Bar values and the Type ID goes into the line values. You may need to activate the secondary axis for the line chart. There a few Markers available and if you add a legend of the Type to the visual, you can pick and choose what colurs these Markers are

JoeBarry_0-1692778670512.png

Thanks

Joe

View solution in original post

2 REPLIES 2
Mark_Berry
Helper I
Helper I

Thanks Joe

JoeBarry
Solution Sage
Solution Sage

Hi @Mark_Berry 

 

How is your Dataset set up? Is the visual above over time?

 

Are you using a star schema? If you are and you are using the Data from your date table for the time reference in the visual, you could create a seperate table for the Events of Milestones. 

DateTypeTypeIDDescription
11.01.2022Event1Car Crash
11.02.2023Milestone2No Traffic
05.08.2022Milestone2Car Launched

 

Create a one to many relationship between the date in your date table and the date in the new table. Create a Line and Bar chart, the data you have already goes into the Bar values and the Type ID goes into the line values. You may need to activate the secondary axis for the line chart. There a few Markers available and if you add a legend of the Type to the visual, you can pick and choose what colurs these Markers are

JoeBarry_0-1692778670512.png

Thanks

Joe

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.