Lesson 8 of 11 · 10 min · Reports and dashboards

Building report pages: visuals, filters, slicers and drill-down

Covers: Power BI Desktop. Updated 13 Nov 2026. Part of the Data Analyst roadmap.

What you will learn

  • Build a report page from visuals using fields and measures
  • Use slicers and the Filters pane, and know the filter levels
  • Understand cross-filtering and highlighting between visuals
  • Drill down, drill up and drill through
  • Add tooltips, bookmarks and check performance

In simple words

A report is a set of pages. Each page holds visuals, such as charts, tables and cards, that show your data. What makes Power BI different from a static chart is that visuals are connected: click one bar and the other visuals change to match. You also give the reader controls to slice the data and to zoom from totals down to details, without making a new report for every question.

Words to know

  • Visual: one chart, table, card or map on a report page.
  • Slicer: an on-page control that filters the visuals.
  • Drill-down: moving down a hierarchy, such as from year to quarter to month.
  • Drill-through: jumping from a number to a detail page filtered to that item.

Report view basics

In Power BI Desktop, the three views on the left are Report (build visuals), Table/Data (see the data) and Model (relationships). In Report view the Fields pane lists your tables, measures and columns; the Visualizations pane picks the visual type and its field wells (Axis, Legend, Values, and so on); the Filters pane controls filters; the canvas is the page.

To build a visual: click an empty spot on the canvas, then tick fields or drag them into wells, then choose the visual type. Use measures for values and dimension columns for axes and categories.

Question Visual
One headline number Card (or KPI visual with target and trend)
Compare categories Clustered bar or column (bars for long labels)
Trend over time Line or area chart with the date hierarchy
Parts of a whole stacked bar or a donut with a few slices; treemap for many
Ranking sorted bar chart with a Top N filter
Detail and exact numbers Table or matrix (like a pivot table)
Geography filled map with correct data categories
Relationship between two numbers Scatter

(The charts lesson explains how to choose.)

Formatting visuals

Select the visual and open the Format (paintbrush) tab: titles, axis labels, data labels, colours, grid, legends. Make titles say what the visual shows ("Sales by city, 2025"). Set number formats on measures (₹, thousands, percentages). Use the same colour for the same thing across the whole report. Turn off what does not help: heavy gridlines, redundant legends, unnecessary borders.

Slicers

Add a Slicer visual, drag a dimension column into it (City, Category, Year). Styles: list, dropdown, tile buttons, between (for numbers and dates), relative date (the last 30 days). Tips:

  • Use dropdown slicers for fields with many values and tiles for a few.
  • Sync slicers (View > Sync slicers) apply one slicer across several pages.
  • Use slicers from dimension tables (Customer, Date), not from the fact table, so they filter correctly.
  • Limit the number of slicers; too many make a page confusing.
  • Use Edit interactions (Format tab) to stop a slicer from filtering a particular visual.

The Filters pane

The pane has three levels:

Level Applies to
Visual only that visual (for example a Top 5 filter)
Page all visuals on the page
All pages every page in the report

Filter types: Basic (tick values), Advanced (is, contains, greater than), Top N, Relative date and Relative time. Visual-level Top N is the standard way to show "top 10 products". You can lock or hide filters from report viewers. Remember a filter in the pane, a slicer and a measure's own CALCULATE all combine to make the filter context seen in the DAX lessons.

Cross-filtering and highlighting

Click a bar, a slice or a table row, and the other visuals on the page respond: either filtered (other visuals show only the selection) or highlighted (other visuals show the selection as a darker part of the whole). Change the behaviour per pair of visuals with Format > Edit interactions. Ctrl+click selects several. Clicking an empty area clears the selection. Cross-filtering relies on relationships, so a visual with no relationship to the clicked table will not change; if it does not, check the model.

Hierarchies, drill-down and drill-up

A hierarchy is an ordered set of fields, such as Year > Quarter > Month > Day, or Category > Subcategory > Product. Drag the fields into the Axis well in order (or build the hierarchy in the Fields pane). The visual's header offers:

  • Drill mode on (the arrow): clicking a bar drills into that item.
  • Go to the next level (the double arrow): shows everything at the next level.
  • Expand all down one level: shows both levels at once.
  • Drill up (the up arrow) returns.

Use drill-down to move from "sales by category" to "sales by product in the category" without leaving the page, keeping one chart where ten would be needed.

Drill-through

Drill-through lets a user right-click a value (a product, a customer) and go to a detail page already filtered to it.

  1. Add a page, for example "Product detail".
  2. Drag the field (Product[Name]) into Drill-through filters on that page.
  3. Build the detail visuals (sales trend, customers, returns).
  4. Add a back button (Insert > Buttons > Back).

Users then right-click a product anywhere in the report and choose Drill through > Product detail. Hide the detail page from the tab bar if it only makes sense with a selection.

Tooltips, bookmarks and buttons

  • Tooltip pages: design a small page (set page size to Tooltip) and assign it to a visual, so hovering shows a mini chart.
  • Bookmarks save a state of the page (filters, selections, visibility). With buttons they can create toggles such as "Show chart / Show table".
  • Buttons and page navigation build menus for reports with several pages.
  • Conditional formatting (background colour, data bars, icons by rules) highlights values that need attention.

Keep it fast and correct

  • Fewer visuals per page (a good guide is under about 8 to 10 visuals); each one is a query.
  • Use Performance analyzer (View) to record how long each visual takes and copy its query to the DAX query view.
  • Avoid very high-cardinality columns in visuals (a table of a million rows).
  • Test interactions: click every slicer and visual and check the totals against a known figure.
  • Check on a phone layout (View > Mobile layout) if people will open it on mobile.
  • Check accessibility: alt text for visuals, tab order, sufficient colour contrast, no meaning by colour alone.

Common mistakes

  • Cluttered pages with too many visuals and slicers.
  • Slicers built from fact-table columns, which behave oddly.
  • Forgetting Edit interactions, so a click filters visuals it should not.
  • Showing the wrong measure (an implicit sum of a percentage) in a card.
  • Not testing the report as a viewer would.

Try it yourself

  1. Build a page with three cards (Sales, Orders, Average order value), a line chart by month and a bar chart by city.
  2. Add slicers for Year and Category; try Sync slicers on a second page.
  3. Create a hierarchy of Category > Product and drill down.
  4. Make a Product detail page and set up drill-through with a back button.
  5. Run Performance analyzer and find the slowest visual.

Check yourself

What are the three levels of filters in the Filters pane?

Visual (that visual only), Page (all visuals on the page) and All pages (the whole report).

What is the difference between drill-down and drill-through?

Drill-down moves through the levels of a hierarchy within a visual; drill-through jumps to another page filtered to the selected item.

How do you stop a slicer from filtering a particular chart?

Use Edit interactions and set that chart's interaction with the slicer to none.

Why take slicer fields from dimension tables?

Dimension filters propagate correctly through relationships to the fact table; slicers on fact-table columns can behave unpredictably.

Interview questions

How would you build an interactive sales dashboard in Power BI?

Model the data as a star schema, write explicit measures, build cards and charts with a clear layout, add slicers from dimensions, configure interactions, add hierarchies for drill-down and a drill-through page for detail, then check performance and publish.

What is the difference between a slicer and a filter?

A slicer is an on-page control that report users can change; filters in the Filters pane are set by the author (and can be exposed or hidden) at visual, page or report level.

How do bookmarks help?

They save a view of the report (filters, selections, visual visibility) so you can build navigation, toggles and guided stories with buttons.

Summary

  • Build pages from visuals using measures and dimension fields; choose the visual that suits the question.
  • Use slicers and the three filter levels; control interactions between visuals.
  • Hierarchies give drill-down; drill-through jumps to a detail page.
  • Keep pages light, test interactions and check performance and accessibility.

Going deeper

See how much of this you can explain

A free mock interview asks you new questions on Power BI and dashboards for Data Analyst and scores every answer, with what to fix.