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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ericOnline
Post Patron
Post Patron

Add an Event to Line Chart?

Hello, 

 

How can I add events to a Line Chart?

 

Example:

PowerBIEvent.png

 

Thank you

6 REPLIES 6
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @ericOnline,

 

I'm a little confused about your scenario, what's mean of add events?

 

If it is convenient, could you describe your requirement in more details.

 

I would appreciate it if you could share your sample data and your desired output so that we could help further on it.

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-piga-msft,

 

I think @ericOnline is talking about adding reference lines to graphs.

These lines can be vertical or horizontal depending on the the type of graph.

 

They are quite useful features especially on trend lines where you can easily spot if a specific 'event' has an impact to the metric you are monitoring.

 

Here is an example

 

 

@ericOnline

This image will point you to the location where you can add a reference line to a chart

 

image.png

Thank you for the idea. Do you know how to add a VERTICAL LINE with unique info? Ideally I'd like to have a table of "events" and be able to plot them on the data as a vertical line with a little "flag" describing the event.

 

Ideas?

Hi @ericOnline,

 

The workaround from themistoklis may help you.

 

Have you solved your problem?

 

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello @ericOnline

 

It seems that PowerBI automatically detects where to put the reference line (X or Y axis).

 

There is a workaround which is described here

 

This is also an idea which you can vote here

 

 

Helpful resources

Announcements
March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.