Power BI annotations: how to mark events on your charts, and where each method falls short

The Changeline team · Published · 7 min read

Power BI reports have no built-in annotation feature for marking events on a chart. The usual workarounds are an X-axis constant line from the Analytics pane, an events table plotted as markers with a tooltip, comments in the Power BI service, and data point annotations in the PowerPoint add-in (preview). Each one shows context, none records what changed.

Does Power BI have annotations?

Not in the way GA4 or Looker Studio users expect. A Power BI report has no button that pins a dated note to a chart, so teams build event context with four tools that were made for other jobs.

Here is what each one does, according to Microsoft's documentation:

MethodWhere it livesGood forMain limit
X-Axis constant line (Analytics pane)Inside the visual, in the reportOne or two key dates on a line or column chartEach line is set by hand; it has no owner or reason
Events table plotted as markersIn the semantic modelMany events, filtered with the reportSomeone has to keep the table current
CommentsPower BI service, per report, dashboard or visualDiscussion with @mentionsNot drawn on the chart; needs Pro, PPU or Premium/Fabric capacity
Data point annotations (preview)Power BI add-in for PowerPointA callout on one point in a slideSaved in that slide's add-in instance, not in the report

If your team also uses Looker Studio, the trade-offs are similar to the ones in our article on Looker Studio annotations. GA4 is the exception, with native notes on the timeline, covered in the GA4 annotations guide.

How do I add a vertical line for an event date in Power BI?

Use the X-Axis constant line in the Analytics pane. It draws a vertical reference line at a fixed value on the X axis, which you can name after the event.

  1. Select the line, area or column chart. The Analytics pane only appears when a visual is selected.
  2. Open the Analytics pane.
  3. Expand X-Axis constant line and select + Add.
  4. Set the value to the position of the event on your axis, give the line a name such as "Target ROAS raised", and pick a colour and line style.
  5. Turn Data label on so the name shows on the chart.

Microsoft lists the X-Axis constant line for area, bar, column, line, ribbon and scatter charts, and you can add several lines to one visual. It does not document the behaviour on every axis type, so test it on your date axis before you rely on it in a client report.

The weakness is maintenance. Each line is a hard-coded value inside one visual. Copy the chart to another page and you copy the lines; add a new event and someone has to edit every visual that should show it. The line says when, not who, why or what the value was before.

Read also: Looker Studio annotations: how to mark changes on your charts · Free marketing change log template (Sheets, Excel, CSV)

How do I show events from a table on a Power BI chart?

Keep the events in their own table, relate it to your date table and plot a measure that only returns a value on event days. The markers then follow every filter and slicer in the report.

A typical build looks like this:

  1. Create an Events table
  2. Relate it to the date table
  3. Add an event marker measure
  4. Plot it as markers
  5. Show details in a tooltip

What goes in the events table

One row per change, with at least: Date, Source (Google Ads, Meta Ads, website, tracking, CRM), Change, Owner and Reason. Add a Campaign or Market column if your report filters by them, so events filter with the data.

How the marker works

A measure such as Event marker = IF(COUNTROWS(Events) > 0, [Sales]) returns the metric's value only on dates with an event. Plot it as a second series on the line chart, hide its line and show markers, and the dots sit on top of the metric line exactly on the event days.

To show the details, build a report page tooltip: in the Format pane set Canvas settings to the Tooltip page size, turn on Tooltip under Page information, place a table of events on it, then select that page in the chart's Tooltips card. Microsoft notes that report tooltips are not interactive, are not supported on dashboards, and that a line chart shows one tooltip for all lines.

This is the most flexible method. Its weak point is the table itself: if it is a spreadsheet someone updates on Fridays, the chart is only as complete as that habit.

Where do comments and PowerPoint annotations fit?

They are for conversation and presentation, not for a record of changes. Use them on top of one of the methods above.

Comments work in the Power BI service on dashboards, reports and individual visuals. Select the Comment icon to open the Comments pane, or hover over a visual and choose More options (...) > Add a comment. You can @mention colleagues, and a report comment saves the current filters and slicers as a bookmark. Limits from Microsoft: 2,000 characters per comment, 100 conversations per report or dashboard, and a Pro or PPU licence or Premium/Fabric capacity.

Data point annotations are a preview feature of the Power BI add-in for PowerPoint. You select a point, choose Annotate and type a callout, which can reference the point's values. They are saved with that add-in instance, so they do not appear in the Power BI service or in other slides, and they disappear when filters remove the point.

Both are useful at the end of the process, when you already know the answer and want to show it. Neither helps you find it.

How do I isolate which change caused a movement on a Power BI chart?

Rule out tracking first, then list every change from the days before the shift and test them one at a time. The chart shows when the metric moved; the answer is in what changed just before.

  1. Check that the data is real: compare the drop with a second source, such as backend orders or CRM leads.
  2. Find the first day of the shift and the segment where it sits (channel, campaign, device, market).
  3. Collect the changes from the 7–14 days before: your team's edits, platform automations, site releases, tag changes and outside events.
  4. Keep only the changes that touch the affected segment and test the most likely one first.

Example: a retail client's marketing director opens the monthly Power BI report and asks why online sales fell 25% from Monday. Backend orders fell too, so tracking was fine. The drop sat almost entirely in Google Ads traffic. Lining up the changes from the week before showed a target ROAS raised from 400% to 550% on Friday and a new product page template on Saturday. Organic sales on the new template held steady, so the bid target was the likely cause. The team lowered it, logged the change and added an event marker for both dates. (Names and numbers are illustrative.)

  1. FriGoogle AdsTarget ROAS 400% → 550%
  2. SatWebsiteNew product page template
  3. MonOnline sales down 25%
Example

Online sales per dayMon: −25%

Example · your analytics report

With every change on one timeline, the ROAS target sits two days before the drop, next to the template release, and you can test them one at a time instead of guessing. In Changeline, Google Ads edits are imported automatically with the before and after values, and your team logs the site, tracking and CRM changes in the same project, so that list exists before anyone opens Power BI.

What should each event record so the chart stays useful?

Enough to answer the client's next question without a meeting: when, what, before and after, who and why. A line that only says "campaign change" will not help in three months.

Checklist

  • Date and time of the change
  • Platform or system (Google Ads, website, GTM, CRM)
  • What changed, with the value before and after
  • Who made it, or which automation
  • Why it was made and what you expected
  • Campaigns, markets or pages it affects

Keep this record outside the report, in one marketing change log, and feed Power BI from it. That way the same list serves the chart markers, the monthly review and the next investigation. If you are starting from zero, the marketing change log template gives you the columns.

For client reporting, a list of the changes in the period often explains more than another chart. Our article on the marketing change report shows how to present it, and on Changeline's paid plans the Report button builds that summary for a chosen period.

Answer “what changed?” before the client asks

Changeline puts your team’s changes, imported Google Ads changes and site, tracking and CRM edits on one timeline per client.

Free plan: 1 project, 2 editors, 15 days of history. No card.

FAQ

Can I add a text annotation directly on a Power BI chart?

Not natively. You can place a text box over the visual, but it is positioned by hand and does not move with the data or filters. For notes tied to a date, an X-Axis constant line with a data label or an events table plotted as markers is more reliable.

Can Power BI reference lines be driven by data?

Microsoft's Analytics pane documentation describes constant lines with fixed values plus min, max, average, median and percentile lines calculated from a measure. For many events that come and go with filters, an events table and a marker measure are easier to maintain than one constant line per date.

Do Power BI comments show up on the chart?

No. Comments live in the Comments pane of the Power BI service. A comment on a visual is marked with a chart icon and a report comment saves the filters as a bookmark, but nothing is drawn on the timeline of the chart itself.

Are PowerPoint data point annotations saved in the Power BI report?

No. Microsoft says they are saved with the specific add-in instance in the slide, so they don't appear in the Power BI service or in other add-in instances. Each slide can carry a different set of annotations for the same visual.

Which changes should go into a Power BI events table?

Any change that can move the metric on the chart: bids, budgets and targets, campaign launches and pauses, landing page releases, tag and consent changes, CRM or pricing changes, and outside events such as a promotion or outage. Record the date, owner and before and after values.

Sources

  1. Use the Analytics pane in Power BI Desktop (Microsoft Learn)
  2. Add comments to a dashboard or report (Microsoft Learn)
  3. Create data point annotations (preview) (Microsoft Learn)
  4. Create tooltips based on report pages (Microsoft Learn)