How to Add Comments in Power BI Dashboard

Cody Schneider8 min read

Adding notes and explaining trends directly inside your Power BI dashboard bridges the gap between raw data and actionable insight. It’s what turns a chart from a simple picture into a story someone can easily follow. This guide will walk you through the built-in ways to add comments in Power BI and also cover more flexible, advanced techniques for creating dynamic commentary connected directly to your data.

GraphedGraphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch Graphed demo video

Why Bother Adding Comments to Your Dashboard?

Numbers on a screen are useful, but they rarely tell the whole story on their own. Context is everything. Adding commentary helps your team answer the "why" behind the data without having to schedule a meeting or send a screenshot in Slack.

Here are a few quick reasons why it’s worth the effort:

  • Provide Context: Explain a sudden spike in website traffic ("result of our new ad campaign") or a dip in sales ("due to a supplier issue this week"). This pre-empts questions and reduces confusion.
  • Drive Collaboration: You can @mention specific colleagues to draw their attention to an important metric or ask for their analysis on a particular visual.
  • Document Insights: Create a persistent record of observations directly within the dashboard. When you review performance next quarter, the team’s notes are right there waiting for you.
  • Ask Questions in Place: Point directly to a confusing chart and ask, "Does anyone know why leads from this channel have dropped so sharply?" This keeps the conversation focused.

In short, commentary breathes life into your data, making your dashboards a central hub for data-driven decisions and team communication.

The Two Flavors of Comments in Power BI: Dashboards vs. Reports

Before you start typing, it’s important to understand a key distinction that defines how Power BI is designed. There’s a distinction between a Report and a Dashboard, and it affects how comments work.

  • Reports: This is the multi-page canvas where you build your individual visuals (line charts, bar charts, tables, etc.). Comments left on a Report page are general and apply to the entire page, not a specific visual.
  • Dashboards: A dashboard is a single-page view created by "pinning" visuals from one or more reports. Comments left on a Dashboard are linked to a specific visual tile.

Most of the time, collaboration happens on the report pages or in a published app, so you'll likely be using the report commenting feature more often. Both are useful, just remember where you are leaving your message.

GraphedGraphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch Graphed demo video

Method 1: The Standard Comments Feature

Power BI has a built-in commenting feature that’s straightforward and easy to use. It’s perfect for general discussions and flagging things for team members. To use this, you'll need a Power BI Pro or Premium license, as it relies on the collaboration features of the Power BI service.

Leaving a Comment on a Power BI Report

To comment on a report page in your workspace or in a Power BI App:

  1. Navigate to the report page where you want to add a note.
  2. In the top action bar, look for the Comments button. Click it.
  3. A "Comments" pane will open on the right-hand side of your screen.
  4. Type your message into the textbox at the top of the pane.
  5. To notify a colleague, use the "@" symbol followed by their name, just like on social media (e.g., "@Alex Can you check these numbers?").
  6. Click Post to save your comment. A chat bubble icon will appear on the top bar to show that this report has comments.

Anyone with access to the report can see the conversation thread and reply.

Leaving a Comment on a Dashboard Tile

To comment on a specific visual on a published dashboard:

  1. Hover over the tile you want to comment on.
  2. Click the ellipsis icon () that appears in the top-right corner of the tile.
  3. From the dropdown menu, select Add a comment.
  4. The "Comments" pane will open, already focused on that tile.
  5. Type your insights or questions, @mentioning colleagues as needed, and click Post.

The main limitation of this native feature is that comments aren’t tied to your actual data points. You can’t attach a comment to "March's sales data." The comment is just attached to the general report page or visual tile.

Method 2: Create a Dynamic Comments Log (Advanced)

If you need to leave notes tied directly to specific data points - like a particular month, product, or campaign - you'll need a more robust solution. This method involves creating a separate table just for your comments and integrating it into your Power BI data model. It sounds complex, but it's incredibly powerful.

Here’s the step-by-step process:

GraphedGraphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch Graphed demo video

Step 1: Create a Data Source for Your Comments

You need a place to write and store your comments. This could be a simple Excel file in OneDrive, a Google Sheet, or a SharePoint List. A SharePoint List is often the best choice for team collaboration as multiple people can edit it at once.

Create a simple table with headers like:

  • Date: The date the comment was made.
  • Author: Who wrote the comment.
  • Comment: The text of the comment itself.
  • Category: This is the most important column. This is how you'll link the comment to your data. Whatever you're commenting on (e.g., Product Name, Marketing Campaign, Country), this column needs to hold a value that exactly matches a value in your main data model.

For example, if you sell "Product A," "Product B," and "Product C," your "Category" column in the comments table would contain those exact text values.

Step 2: Connect Power BI to Your Comments Table

  1. In Power BI Desktop, go to Home > Get Data.
  2. Choose the appropriate connector for your source (e.g., Excel Workbook, Google Sheets, SharePoint List).
  3. Connect to your file or list and load the comments table into your Power BI report.

Step 3: Relate Your Tables in the Data Model

This is where the magic happens. You need to tell Power BI how your comments relate to your sales data (or whichever data you’re analyzing).

  1. Go to the Model view in Power BI Desktop (the icon with three connected boxes on the left).
  2. Find your new comments table and your main data table (e.g., 'Sales Data').
  3. Click and drag the "Category" column from your comments table onto the corresponding column in your main data table (e.g., "Product Name").
  4. Power BI will create a relationship (a line) between the tables.

Step 4: Visualize Your Comments

Now, go back to the Report view. Create a visualization to display your comments, such as a Table or Matrix visual. Drag the Author, Date, and Comment fields into the visual.

Because you've defined the relationship, you can now click on a product in a bar chart, and the comment table will automatically filter to show only the comments related to that product. You've successfully created data-contextual commentary!

GraphedGraphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch Graphed demo video

Method 3: Embed a Power App for Real-Time Input (Expert)

For the ultimate interactive experience, you can embed a Power App directly within your Power BI report. This approach allows users to not just view comments but to write and submit new ones without ever leaving the report.

This is an advanced technique that provides "write-back" capabilities. Here’s the general idea:

  1. Create a Power App: Design a simple app with a form where users can type their comments and submit them.
  2. Set Up a Data Source: Have the app save the comments to a data source like a SharePoint List (similar to Method 2).
  3. Connect the Source to Power BI: Make sure your Power BI report is connected to that same SharePoint List.
  4. Embed the App: In Power BI Desktop, add the Power Apps for Power BI visual. Follow the prompts to connect it to your newly created app.

Now, users can interact with charts, see existing commentary, and submit new notes via the embedded app. When the data refreshes, their new comments appear in the report nearly instantly. This creates a truly dynamic feedback loop, but does require some familiarity with the Power Platform.

Best Practices for Dashboard Commentary

  • Be Clear and Concise: Nobody wants to read an essay. Get straight to the point. Example: “Sales spike on the 15th was from the flash sale event. Great work, team.”
  • Use @Mentions Thoughtfully: Tagging someone is a great way to assign a task or get their attention. Don't spam the whole team if the message is only for one person.
  • Create an Action Plan: Have a process for what happens after a comment is made. Who is responsible for reviewing them? Does it create a follow-up task?
  • Date Your Comments: If you're using a text box or another manual method, add the date so your commentary stays relevant as the data updates over time.

Final Thoughts

Whether you're using the simple built-in commenting feature for quick notes or setting up a dynamic table for deep-dive analysis, adding commentary is a game-changer for collaboration. It helps everyone on your team stay aligned and ensures your dashboards are used to drive meaningful discussions, not just display numbers.

While these Power BI methods work for providing a certain layer of commentary, true data collaboration often starts with asking simple questions. We built Graphed to help teams move beyond static visuals and into more of a real-time conversation with their data. Rather than building complex commentary workarounds, our platform lets you ask questions about your marketing and sales data in plain English and get answers in seconds. You can ask follow-ups, brainstorm with your team, and build dashboards just by describing what you want to see, making analytics feel less like configuring a report and more like talking with an expert.

Related Articles