Picking the right visual, and wiring it up with the right interactivity, is what turns a page of charts into a report someone can actually use. This covers choosing a visual for the job, the three filter scopes, drill down versus drillthrough, bookmarks, and the design habits that separate a clear page from a cluttered one.
In this guide
Choosing the right visual
| Need | Visual | Why |
|---|---|---|
| Compare a value across a handful of categories | Bar or column chart | Lines categories up side by side so heights or lengths compare directly |
| Show how a value changes over time | Line chart | Plots each time period in sequence so a rising, falling or flat trend is immediately visible |
| Show one headline number, no breakdown | Card | Deliberately shows just one aggregated number, with no categories, axes or rows |
| Show several fields repeated for a handful of records | Multi-row card | Extends the single-card idea into a short repeated list |
| Show a value against a target on a bounded scale | Gauge | A minimum, a maximum and often a target marker along one simple scale |
| Show value, target and recent trend together | KPI | Combines a current value, a target to compare it against, and a trend indicator |
| Compare one chart across many categories at a glance | Small multiples | Repeats one chart once per category, laid out in a grid |
Table versus matrix
Both list rows of data, but a matrix supports row and column hierarchies with expandable subtotals, behaving like a pivot table, while a plain table stays flat, listing every row with no such nesting.
Slicers, and the three filter scopes
A slicer is an on-page visual a viewer can see and click to interactively filter the other visuals on that page, which is different from a filter set in the Filters pane: that applies quietly, narrowing the data without being its own visible visual on the canvas.
| Filter scope | What it affects |
|---|---|
| Visual-level filter | Only that one single visual it is attached to |
| Page-level filter | Every visual on the current page |
| Report-level filter | Every visual on every page throughout the entire report |
A slicer, by default, only affects the page it sits on. Sync Slicers lets that same selection carry across to other pages too, so a viewer does not have to reselect the same filter page after page.
Drill down versus drillthrough
| Feature | What happens |
|---|---|
| Drill down | Moves from a higher level to a lower level of the same hierarchy, within that one same visual, such as Year down to Month |
| Drillthrough | Right-clicking a data point jumps to a separate, pre-built page already filtered to that exact context |
Spotting the right feature
A report with a summary page and a separate Customer Details page, built in advance to open already filtered to one specific customer, is the textbook drillthrough scenario: a dedicated detail page receiving the clicked context, not a deeper level of the same chart.
Bookmarks and buttons
A bookmark captures the current state of a report page: its filter and slicer selections, and which visuals are visible, as a saved snapshot that can be returned to later or wired to a button.
| Button type | What it does on click |
|---|---|
| Navigation button | Simply jumps to a different page, or a previous view |
| Bookmark button | Restores the precise combination of filters, slicer picks and visibility saved inside a specific bookmark |
Bookmarks combined with buttons are the standard way authors build tab-like toggles on a single page, where each button switches between a different saved view, giving a page the feel of a small guided app rather than a flat set of charts.
Conditional formatting
Conditional formatting changes how a cell or data point displays, such as its colour or an icon, based on the value it holds, without altering the underlying data or row order. A rule does not have to read the same column it is colouring: it can be pointed at a different field or measure entirely, for example colouring a Sales column based on a separate Target Achieved percentage measure.
Design habits that matter
- Keep the same colour for the same category across every visual on a page. A viewer then recognises that category at a glance on every chart, instead of re-reading each legend from scratch.
- Do not pack a page with too many visuals and colours. A crowded page raises the cognitive load on the viewer, making it harder to quickly spot what actually matters.
- Trim excessive decimal precision. A number like 1,204,582.37291 adds visual clutter without adding insight a viewer actually needs.
Tooltips, page size, and canvas extras
A report-page tooltip goes beyond the default hover text: an author designs a whole small report page, with its own visuals, and sets it as the tooltip, so hovering reveals a richer, custom-built mini view of that data point.
Most Power BI reports are designed around a 16:9 widescreen page, matching a typical monitor or presentation slide, which is why reports default to landscape rather than portrait. Text boxes, shapes and images add static annotation and branding, a title, a company logo, an explanatory note, rather than anything connected to the data itself. Tab order, set per page, controls the sequence assistive technology such as a screen reader moves through a page’s visuals, which matters for accessibility even though it has no visible effect for a mouse user.
Common mistakes
- Confusing drill down with drillthrough. One stays on the same visual at a deeper hierarchy level; the other jumps to a whole separate page.
- Treating a bookmark as just a saved screenshot. It is a saved configuration, filters and visibility, not a frozen copy of the data or an image.
- Using a card when a KPI or gauge was meant. A card shows one number with no target context at all; a KPI or gauge is built specifically around progress toward a goal.
- Assuming conditional formatting can only read its own column. It can be driven by a completely different measure.
- Ignoring tab order. It has no visible effect for a mouse user, which is exactly why it is easy to forget, but it matters for every screen reader user.
Cheat sheet
| Question | Answer |
|---|---|
| Which visual compares categories side by side? | A bar or column chart |
| Which visual shows a trend over time? | A line chart |
| What supports row and column hierarchies like a pivot table? | A matrix, not a plain table |
| What is the widest filter scope? | Report-level |
| What lets one slicer selection reach other pages? | Sync Slicers |
| What stays on the same visual at a deeper level? | Drill down |
| What jumps to a separate, pre-filtered page? | Drillthrough |
| What does a bookmark save? | Filters, slicer picks and visual visibility |
| What is the default report page shape? | 16:9 widescreen |
| What controls screen-reader navigation order? | Tab order |
Try it yourself
Quick check
A report author wants a single page where clicking “Monthly View” or “Quarterly View” swaps which slicer selections and which visuals are showing, like a pair of tabs on one page. Which two features combine to build this?
Show answer
Bookmarks and buttons. Two bookmarks are saved, one for each view’s filters and visibility, and a button is set to apply each bookmark on click, which is the standard pattern for building tab-like toggles on a single page.
Frequently asked questions
What is the difference between a slicer and a filter in Power BI?
A slicer is a visible, clickable visual sitting on the report canvas. A filter set in the Filters pane applies quietly, narrowing a visual, page or the whole report without being its own visible element.
What is the difference between drill down and drillthrough in Power BI?
Drill down moves a single visual from a higher level to a lower level of its own hierarchy, such as Year to Month, staying on that same visual. Drillthrough jumps to a separate, pre-built page that is already filtered to the clicked context.
What does a Power BI bookmark save?
A bookmark saves the current state of a report page: its filter and slicer selections, and which visuals are visible, as a snapshot that can be restored later or triggered by a button.
What is the difference between a table and a matrix visual in Power BI?
A matrix supports row and column hierarchies with expandable subtotals, like a pivot table, while a plain table lists every row flatly with no such nesting.
What is a KPI visual used for in Power BI?
A KPI visual shows a value measured against a target or goal, typically alongside a trend indicator showing recent progress toward that target.
What is the default page size for a Power BI report?
A 16:9 widescreen layout, matching a typical monitor or presentation slide, which is why most reports are designed in landscape rather than portrait.
Test yourself
Timed questions on Visuals and Report Design, with an explanation for every answer.