Embed Report Chart on Record Page in Salesforce

When I work with sales teams, one pattern shows up again and again: reps live on the Opportunity record page, while managers live in Reports and Dashboards.

The problem is that reps rarely open dashboards during the day, so they miss trends like pipeline health, win rates, or product mix.

Managers then complain that “the team has no visibility”, even though the data exists. A very simple fix is to embed a Report chart directly on the record page.

When your sales rep opens an Opportunity, they immediately see a chart of related deals, revenue by product, or stage conversion.

The same applies to support teams looking at Case records or account managers working in Accounts.

In this guide, I’ll show you the exact steps to embed report chart on record page in Salesforce Lightning, along with tips I’ve learned from real implementations.

This Tutorial Covers:

Why Embed Report Charts on Record Pages in Salesforce?

Putting a chart directly on a record page turns raw data into instant, actionable insight. Your users don’t need to leave the record, open a dashboard, or hunt for the right report.

Here are a few practical use cases:

A sales manager wants reps to see Revenue by Lead or Revenue by Product whenever they open an Opportunity, instead of checking a central dashboard. You can build a focused report (similar to how you’d create a revenue by lead report in Salesforce) and reuse its chart on key record pages.
A support lead wants a quick “Open Cases by Owner” visualization directly on the Case record, inspired by the pattern used in an Open Cases by Owner report in Salesforce.
An account executive wants to see historical deal volume for a specific Account in context, without opening a separate dashboard or tab.

Once you understand the pattern, you can use it in Sales Cloud, Service Cloud, or any custom app where users benefit from visual cues right on the record.

How to Embed Report Chart on Record Page in Salesforce

Below, I will explain in detail how to embed a report chart on the record page in Salesforce.

Prerequisites and Assumptions

Before you embed a report chart into a record page, make sure a few basics are in place:

You’re working in Salesforce Lightning Experience.
You have access to Reports and Dashboards via profile or permission set.
You can edit Lightning record pages using the Lightning App Builder.
You already have a report whose chart makes sense on the record page (we’ll cover how to build one quickly).

If you’re comfortable with Lightning record pages, navigation menus, and header customization, the steps will feel similar to setting up custom navigation menus in Salesforce or creating a custom home page in Salesforce Lightning.

Step 1: Decide Where You Need the Report Chart

Before touching configuration, choose:

Which object: Account, Opportunity, Case, Contact, or a custom object.
Which record page: standard page, custom Lightning page, or a specific App’s record view.
What question the chart should answer at a glance.

Examples:

On the Opportunity page, show “Total pipeline amount by stage” or “Historical revenue for this Account”.
On the Account page, show “Open Cases by priority” or “Opportunities by close date month”.
On the Case page, show “Cases by owner” or “Cases by status”.

If you haven’t standardized your Lightning record pages yet, it can help to review how to activate a record page in Salesforce Lightning, so you know which page you’re editing.

Step 2: Create a Report with a Useful Chart in Salesforce

To embed a chart, you first need a Report with a chart configured. Here’s a simple pattern using an Opportunity example.

2.1 Create the Base Report

Go to the Reports tab.
Click New Report.
Choose a report type, for example Leads or Leads with Converted leads information.
Click Continue to open the report builder.

how to create a lead conversion report in Salesforce

In the report builder, define:

Filters: For example, “All Opportunities”, “Close Date = Current FY”, “Stage = Open” depending on the insight you want.
Groupings: Drag a field like Stage, Close Date, or Owner into the “Group Rows” area. This grouping drives your chart categories.

If you’re comfortable building more advanced reports, you can reuse patterns from guides like group a report by month in Salesforce or export a report to Excel in Salesforce to validate the data.

2.2 Add a Chart to the Report

In the report builder, click Add Chart (usually in the top right).
Choose a chart type (bar, column, donut, line) that matches your grouping.
Configure:
- X-axis: The grouped field (Stage, Month, Owner).
- Y-axis: The summary you care about (SUM of Amount, COUNT of records).
Adjust chart settings (e.g., show values, legend placement) for clarity.

Save and run the report to confirm that:

The chart shows the right data.
The visual is easy to understand for your users.

Run Opportunities by month report in Salesforce Lightning

Pro Tip: I’ve found that it’s better to keep these embedded charts very focused—one question per chart. Don’t try to pack multiple groupings or complex filters; your users will ignore a cluttered visual.

Step 3: Add the Report Chart to a Dashboard (If Needed)

In many orgs, admins prefer to embed Dashboard components rather than raw report charts, because dashboards give more control over layout and multiple charts.

If your org follows this pattern:

Open the Dashboards tab.
Click New Dashboard or edit an existing one.
Add a component linked to your report:
- Choose the report you created.
- Select the chart type and settings.
Arrange the component on the dashboard.

You now have a dashboard that uses your report chart. This is useful if:

You want to reuse the same chart in multiple places.
You plan to add a Salesforce report as a dashboard for broader visibility as well as on the record page.

However, for a simple embedded experience, you can also use the report chart directly without a dashboard, depending on your page design.

Step 4: Open the Lightning Record Page in App Builder

Now we switch to Lightning App Builder to embed the chart on the record page.

Navigate to a sample record, for example an Opportunity.
In the top right, click the Setup gear icon.
Select Edit Page. This opens the Lightning App Builder for that record page.

If you do not see the Edit Page option, you may need to review profile permissions or check if the page is managed, similar to the scenario described in the edit page option missing in Salesforce Lightning guide.

Inside App Builder, you’ll see:

The current record page layout.
The components list on the left.
The properties panel on the right when you select a component.

Step 5: Choose the Right Component to Embed the Chart

There are two common ways to show a chart on a record page:

Report Chart Component – shows a chart from a specific report.
Dashboard Component – shows a component from a dashboard.

5.1 Using the Report Chart Component

For a direct report chart:

In the Components pane, search for Report Chart.
Drag the Report Chart component onto your page layout:
- Common locations: right-side sidebar, below the main details section, or a dedicated “Insights” region.
With the component selected, configure its properties:
- Report: Choose the report you created earlier.
- Chart: Select the chart defined in that report.
- Optional filters: some orgs use standard report filters; others rely on the report configuration alone.

Embed Report Chart on Record Page in Salesforce

This approach is ideal when the chart is unique to this page, and you don’t need more dashboard flexibility.

5.2 Using the Dashboard Component

If you want a dashboard slice:

In the Components pane, search for Dashboard.
Drag the Dashboard component onto the page.
In the properties panel:
- Choose the Dashboard you configured.
- Pick the component or adjust the view as needed.

Adding a Dashboard to App page in Salesforce

This is useful when:

The chart is part of a larger dashboard experience.
You plan to show multiple charts side by side on the record page.

Either way, make sure the component placement respects your existing page structure. For example, if you already display alerts and notifications in Salesforce, don’t crowd them with charts in the same area.

Step 6: Make the Chart Contextual to the Current Record

By default, a report chart or dashboard component may show org-wide data. For a record page, you usually want the chart to focus on the specific record being viewed.

There are two key techniques:

6.1 Filter the Report by a Related Field

Design the report to filter by a field related to the current record. For example:

On Account record pages:
- Report filter: Account Id = Current Record’s Account Id (using a filter or custom report type).
On Opportunity record pages:
- Report filter: Account Name = Current Record’s Account or Owner = Current Record’s Owner.
On Case record pages:
- Report filter: Account Id or Contact Id.

Depending on your report type, you may need custom report types that join related objects. This is similar to the thinking used when you create a custom object in Salesforce and design reporting around it.

Salesforce Embed a Report chart to lightning Custom Record Page

6.2 Use Dynamic Dashboards Where Appropriate

If you’re using dashboard components:

Consider Dynamic Dashboards, which show data according to the viewing user’s security context and filters.
For team-level views, this ensures that each user sees only the data they’re allowed to see.

Set the dashboard’s “View as” setting carefully so the chart respects profile-, role-, and permission-set-based access.

Step 7: Save and Activate the Updated Record Page

Once you’ve placed and configured the chart:

Click Save in the Lightning App Builder.
Click Activate to control:
- Whether this page is the org default for the object.
- Whether the page is app-specific (for example, only in the Sales app).

If you’re unsure which activation option to pick, revisiting how to activate a record page in Salesforce Lightning can help clarify the choices.

After activation:

Navigate back to a record.
Confirm that the chart appears and shows the expected data.
Test with different users to ensure they see the right information and have access to the underlying report.

Step 8: Refine User Experience and Performance

Once the report chart is live on the record page, watch how users interact with it:

Ask a few users what they understand from the chart at a glance.
Check whether the chart loads quickly or feels slow.
Adjust groupings or chart types if users are confused.

You can combine this with other UX improvements like Salesforce Lightning header branding and navigation or showing logged-in user details in the Salesforce header to create a cohesive, insightful workspace.

Things to Keep in Mind

Keep charts focused
Use one chart per business question. A simple “Open Opportunities by Stage” on the record page is more useful than a complex multi-metric visual.
Respect data visibility
Make sure profiles, roles, and permission sets allow access to the underlying report and dashboard. If users can’t run the report, the chart may show errors or blank data.
Watch performance
Heavy reports with many filters, joins, or complex formulas can slow down record page load time. Test with real data volume and adjust filters or report type if needed.
Align filters with context
Design your report filters to match the record context. If your Account page chart shows data across the entire org instead of for the current Account, users will ignore it.
Avoid layout clutter
Don’t stack too many components on the record page. Keep charts in a dedicated “Insights” section and avoid overlapping with important actions or notifications.
Document the pattern
Write a short internal guide explaining how you built and embedded the chart. This helps other admins replicate the pattern for cases, leads, or custom objects.

Frequently Asked Questions

How do I create a report chart before embedding it on the record page?

First, build a Report with meaningful filters and groupings, then add a chart directly in the report builder. Choose a chart type that matches your data and keep it simple—one grouping and one measure. Save and run the report to verify the visual before you embed it on the record page.

Can I embed multiple report charts on the same Salesforce record page?

Yes, you can drag multiple Report Chart components or dashboard components onto a single record page. However, be cautious: too many charts can slow down page load and overwhelm users. It’s usually better to start with one or two key charts, then expand only if users clearly request more visuals.

How do I make the report chart show data only for the current record?

Design your report filters and report type so they relate directly to the current record’s fields. For example, filter Opportunities by the Account Id or filter Cases by the current Account or Contact. When the chart is embedded, it will reflect the data that matches those filters, giving users a focused view tied to the record they’re viewing.

Can I use a dashboard instead of a report chart on the record page?

Absolutely. You can embed a Dashboard component on the record page and show one or more dashboard charts. This is useful when you want to reuse existing dashboards or show multiple metrics together. Just remember to configure the dashboard’s “View as” setting correctly and consider using Dynamic Dashboards so users see data appropriate to their access level.

What permissions are required for users to see embedded report charts?

Users need permission to access Reports and Dashboards, as well as visibility to the underlying data via profiles, roles, and permission sets. If a user lacks access to the report, they may see an error or an empty chart. It’s good practice to test with a typical end-user profile to confirm the chart works as expected.

Will embedding report charts affect my page load performance?

Embedding charts can affect performance if the underlying reports are heavy or poorly designed. Large datasets, many joins, and complex formulas slow down report rendering. To minimize impact, keep reports focused, avoid unnecessary filters, and test in a sandbox or low-traffic time before rolling out to all users.

Conclusion

Embedding a report chart onto a Salesforce record page is a simple way to bring real-time insight directly to where your users work. Start with a focused report, embed a clear chart, test the performance, and then build on the pattern gradually across more objects. I hope you found this article helpful.