Portfolio Slicer in Excel: Build an Interactive Dashboard

Charts & pivot tables · Updated November 21, 2026

A portfolio slicer in Excel is a clickable filter for a PivotTable or Excel table, letting you narrow holdings by fields such as asset class, account, or sector. To add one to a PivotTable in Microsoft Excel for Microsoft 365 on Windows, select the PivotTable, choose PivotTable Analyze > Insert Slicer, select the fields to filter by, and choose OK.

What a portfolio slicer does

A slicer is a visual control made up of buttons for the distinct values in a data field. Clicking a button filters the connected table or PivotTable; clicking another value changes the selection. For a portfolio summary, that can make it easy to view only equities, one account, a particular sector, or a chosen investment type without editing the source records.

Slicers are useful for exploring a report, but they do not create investment calculations or fetch current prices. Your workbook must already contain the information and calculations you want to summarize. A slicer also filters only the report objects connected to it, so a control labeled Account will not automatically filter every chart or PivotTable on a dashboard.

For example, a holdings table might contain four positions: $4,000 in an equity, $3,000 in another equity, $2,000 in a bond fund, and $1,000 in cash. A PivotTable could show a total value of $10,000. Selecting Equity in an Asset Class slicer would show the two equity positions, totaling $7,000, if the slicer is connected to that PivotTable.

Prepare portfolio data before adding a slicer

Slicers work best when the source is a clean, rectangular dataset: one header row, one record per row, and one kind of information in each column. Avoid merged cells, blank header names, subtotals inside the data, and decorative title rows within the range. Use consistent labels, so the same asset class is not entered as both “Fixed Income” and “Fixed income.”

A basic holdings table could have columns for Account, Ticker, Asset Class, Sector, Shares, Price, and Market Value. Each row should represent a holding at a defined valuation point. If the same security is held in two accounts, use a separate row for each account when you need to filter by account.

If Market Value needs to be calculated from shares and price, put Shares in column E, Price in column F, and Market Value in column G, with the first holding on row 2. In G2, enter =E2*F2 and fill the formula down. With 8 shares in E2 and a sample price of $50 in F2, the result is $400. This is only an arithmetic example; the workbook does not verify whether a price is current or appropriate.

For easier maintenance, select the data and choose Insert > Table, then confirm that the table has headers. A table can expand as new rows are added, although the PivotTable still needs refreshing to summarize updated records. Give the table a clear name on the Table Design tab if you want to identify its source easily.

Create a PivotTable and insert the slicer

  1. Click a cell in the holdings table. Choose Insert > PivotTable and confirm the table or range in the dialog. Choose where to place the PivotTable, then select OK.
  2. In the PivotTable Fields pane, place fields in the report areas. For a simple portfolio view, drag Asset Class to Rows and Market Value to Values. Dragging Account to Filters is another option, but a slicer gives users a more visible way to change that filter.
  3. Click inside the completed PivotTable. Choose PivotTable Analyze > Insert Slicer, select fields such as Account and Asset Class, and choose OK. Excel adds a separate slicer for each field you selected.
  4. Move and resize the slicers near the PivotTable. Click a slicer button to filter the report. Use the clear-filter icon on the slicer to remove its current selection and show all values again.

If the Values area displays a count rather than a sum, check that Market Value contains numbers rather than numbers stored as text, and review the field’s Value Field Settings. Choose Sum when that is the intended measure. The result should be checked against the underlying records, especially when a report will inform decisions.

Choose useful slicer fields and report measures

Good slicer fields represent categories a reader will genuinely want to compare. Account, asset class, sector, currency, and region are common examples when those columns exist in the data. A slicer for Ticker can be useful for a small watchlist, but hundreds or thousands of ticker buttons can become unwieldy. Slicers are most readable when their categories are reasonably limited and consistently named.

Choose measures that match the question. Sum of Market Value answers how much the selected holdings are worth according to the source prices. A count of Ticker can show the number of records, but it may not equal the number of distinct securities if the same ticker appears in several accounts. A sum of Shares is not a meaningful total across different securities, because one share of one instrument is not equivalent to one share of another.

To show each asset class as a share of the displayed portfolio, use the PivotTable value field settings and the Show Values As options, such as % of Grand Total. Be clear about what the denominator represents. When a slicer filters out accounts or asset classes, the displayed grand total may be the total of the filtered report, not the original full portfolio. If the report must show both filtered values and a constant whole-portfolio denominator, plan that calculation separately rather than assuming a slicer preserves it.

Connect slicers to multiple PivotTables and charts

A dashboard may contain separate PivotTables for account totals, asset-class allocation, and a PivotChart. To make one slicer control several objects, select the slicer and use the Slicer tab’s Report Connections command. Select the compatible PivotTables in the list and confirm. A PivotChart based on a connected PivotTable generally reflects the same filter.

If a PivotTable does not appear in Report Connections, it may not share a compatible data source or PivotTable cache with the other report. PivotTables built separately from different source ranges may not be connectable through the same slicer. A practical approach is to build related reports from the same Excel table or shared data model, then check Report Connections rather than assuming the slicer controls every object.

On Excel for Mac, the ribbon layout and labels can differ somewhat from Windows, but PivotTables and slicers are available in Microsoft 365 desktop Excel. Select the PivotTable and look for the PivotTable analysis commands to insert a slicer; select the slicer to find its report-connection options. Excel for the web has a different interface and feature availability can vary, so use the desktop app if a needed command is not present.

Refresh, date filters, and common problems

A slicer filters the data currently available to its connected report; it does not guarantee that the PivotTable has incorporated edits or newly added records. After updating source data, choose Data > Refresh All, or right-click the PivotTable and choose Refresh. If new rows are missing, confirm that they are inside the source Excel table or range, then refresh again.

For a date field, a Timeline may be more convenient than a slicer with many individual dates. With a PivotTable selected, use PivotTable Analyze > Insert Timeline if Excel offers a usable date field. A timeline is a separate visual filter designed for date ranges; it is not a replacement for a category slicer such as Account.

Other frequent issues have simple causes:

  • Unexpected categories: Check for inconsistent spelling, extra spaces, or blank values in the source field.
  • Wrong totals: Confirm that the value field is summarized as Sum, not Count, and that the source values are numeric.
  • New holdings do not appear: Confirm the rows belong to the source table, refresh the PivotTable, and check whether the slicer itself needs to be resized to display more buttons.
  • Only one report changes: Open Report Connections and connect the slicer to other compatible PivotTables.
  • Repeated securities appear as multiple records: Decide whether the report should show each account-level position or aggregate records by security; those are different views, not necessarily an error.

Slicers compared with ordinary filters

Column filter arrows are compact and useful for cleaning or inspecting a table, but they are less obvious as dashboard controls. A slicer makes available values visible as buttons and is easy for someone unfamiliar with the workbook to operate. It also takes more screen space, particularly when a field has many distinct values.

Use a slicer when the workbook is meant to be explored interactively and the choices are meaningful to the reader. Use ordinary table filters for quick, one-off inspection of source rows. PivotTable report filters can keep a report compact, but they show the selected value in a dropdown rather than offering the more visible button interface of a slicer. These controls all filter data; none should be mistaken for a live market-data feed.

Frequently Asked Questions

Can I add a slicer directly to an Excel table?
Yes. Click inside the table, then choose Table Design > Insert Slicer, select one or more columns, and choose OK. This filters the table rows directly. A PivotTable slicer is the better choice when you want a summarized report, and table slicers do not automatically control unrelated PivotTables.

Why is Insert Slicer unavailable?
Check that you selected a supported Excel table or clicked inside a PivotTable, rather than a blank cell or a chart. If you are working in Excel for the web or a different edition, the available commands may differ; try opening the workbook in Microsoft 365 desktop Excel.

Can one slicer filter a PivotTable and a regular table together?
Not as a single shared filter across those different report types. A table slicer filters its table, while a PivotTable slicer connects to compatible PivotTables. If you need coordinated dashboard views, build the related summaries as PivotTables from a compatible source and configure Report Connections.

Does a portfolio slicer update stock prices?
No. A slicer only filters records already in the workbook. Prices must be entered, imported, or supplied by a separate data connection or feature, and those sources have their own update behavior and limitations.

How do I show every holding again?
Use the clear-filter icon in the slicer to remove its selection. If other slicers are also active, clear each one that is restricting the report; one slicer’s clear button does not clear selections in the others.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.