New: 6 free SQL practice datasets with 300+ questions — try the SQL Compiler →
Power BI

Power BI Visuals and Report Design

Power BI visuals and report design explained: choosing the right chart, slicers versus filters, drill down versus drillthrough, bookmarks and design rules.

Upskly AI Team October 5, 2026 8 min read
Power BI Visuals and Report Design

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

Seven common needs, seven purpose-built visuals
NeedVisualWhy
Compare a value across a handful of categoriesBar or column chartLines categories up side by side so heights or lengths compare directly
Show how a value changes over timeLine chartPlots each time period in sequence so a rising, falling or flat trend is immediately visible
Show one headline number, no breakdownCardDeliberately shows just one aggregated number, with no categories, axes or rows
Show several fields repeated for a handful of recordsMulti-row cardExtends the single-card idea into a short repeated list
Show a value against a target on a bounded scaleGaugeA minimum, a maximum and often a target marker along one simple scale
Show value, target and recent trend togetherKPICombines a current value, a target to compare it against, and a trend indicator
Compare one chart across many categories at a glanceSmall multiplesRepeats 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.

The three filter scopes in the Filters pane, narrowest to widest
Filter scopeWhat it affects
Visual-level filterOnly that one single visual it is attached to
Page-level filterEvery visual on the current page
Report-level filterEvery 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

Both go deeper; only one of them leaves the visual
FeatureWhat happens
Drill downMoves from a higher level to a lower level of the same hierarchy, within that one same visual, such as Year down to Month
DrillthroughRight-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.

Two kinds of button, two very different jobs
Button typeWhat it does on click
Navigation buttonSimply jumps to a different page, or a previous view
Bookmark buttonRestores 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

Quick answers
QuestionAnswer
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.

Take the Quiz
Upskly AI Team
Learning made simple
Scroll to Top