| Concept | Description |
|---|---|
| Layout and Style | |
| Report Pages | Tabbed canvas where each page tells part of the story |
| Layouts | Grids, alignment, and spacing that bring rhythm to pages |
| Themes | Colour palette and typography defaults applied across visuals |
| Interactivity | |
| Bookmarks | Saved view states for guided storytelling and toggling layouts |
| Drill-Through | Right-click navigation that filters another page to the chosen value |
| Buttons and Actions | Buttons configured with bookmarks, drill-through, and URL actions |
| Tooltips | Hover-over panels that reveal extra detail about a data point |
| Page Navigation | Built-in navigators that switch between report pages |
8 Creating Reports
NoteWhat Is a Power BI Report?
A report in Power BI is a collection of visualizations, filters, and interactive elements arranged across one or more pages, all connected to the same data model. Where the previous chapter focused on individual visual types, this chapter focuses on the report as a whole: how pages are structured, how the layout is designed, how filters and slicers give users control over what they see, and how navigation elements tie multiple pages together into a coherent experience.
A well-designed report does not just present data. It guides the reader through a story, makes the key insights immediately visible, and allows users to explore the data further at their own pace.
8.1 Report Structure and Pages
8.1.1 Report Pages and Page Navigation
NoteWorking with Report Pages
Every Power BI report file can contain multiple pages. Each page is an independent canvas with its own set of visuals, but all pages share the same underlying data model. Pages are shown as tabs at the bottom of the Power BI Desktop canvas. You can add, rename, duplicate, reorder, and delete pages to structure the report into logical sections.
A typical multi-page report might have one page for an executive summary, a second for regional analysis, a third for product performance, and a fourth as a drill-through detail page. Organizing content across pages prevents any single page from becoming overcrowded while allowing each section to tell its own focused part of the story.
[Insert screenshot of the Power BI Desktop canvas showing multiple page tabs at the bottom, with one tab active and a right-click context menu visible showing options like Rename Page, Duplicate Page, Delete Page, and Hide Page]
NoteManaging Pages
To work with report pages:
- Add a page — click the + icon at the right end of the page tabs, or right-click any tab and select New Page
- Rename a page — double-click the tab name and type a new name, then press Enter
- Reorder pages — click and drag a page tab left or right to change its position
- Duplicate a page — right-click the tab and select Duplicate Page. This copies the page layout and all visuals, which is useful when building similar views for different regions or time periods
- Hide a page — right-click the tab and select Hide Page. Hidden pages do not appear to report consumers in the Power BI service but remain accessible to report editors in Desktop. This is commonly used for drill-through pages and tooltip pages that are not intended to be navigated to directly
[Insert screenshot of a right-click context menu on a page tab showing Add Page, Duplicate Page, Rename Page, Hide Page, and Delete Page options]
TipName Pages Descriptively
Page names appear as tab labels in the Power BI service and in navigation buttons. Use clear, descriptive names that communicate the content of the page immediately, such as “Executive Summary”, “Sales by Region”, or “Product Detail”. Avoid generic names like “Page 1” or “Sheet 2”, which give the reader no guidance about what they will find.
8.1.2 Report Layout and Design Principles
NoteDesigning for Clarity
Report design in Power BI is not just about placing visuals on a canvas. It is about creating a layout that communicates data clearly and efficiently. A well-designed report page guides the reader’s eye from the most important information at the top to the supporting detail below, uses consistent spacing and alignment, and avoids unnecessary visual clutter that competes with the data itself.
The following principles form the foundation of effective Power BI report design.
NoteThe Inverted Pyramid Layout
Arrange content on each page using the inverted pyramid principle: place the most important, highest-level summary at the top of the page (Cards and KPI visuals), followed by the main analytical charts in the middle, and the most detailed or granular content (tables, matrices, drill-through links) at the bottom. This structure matches how most readers scan a page: top to bottom, left to right.
[Insert screenshot of a well-structured report page showing a row of Card visuals at the top, two or three charts in the middle section, and a table at the bottom, with clear visual hierarchy]
NoteAlignment and Spacing
Consistent alignment and spacing make a report look professional and intentional. Use the Format ribbon’s alignment tools to align the edges of visuals precisely. Maintain equal spacing between visuals using Distribute Horizontally or Distribute Vertically. Group visuals that belong together using Power BI’s Group feature so they can be moved and aligned as a unit.
Avoid placing visuals edge to edge with no breathing room. A small consistent margin between visuals (around 8 to 12 pixels) gives the page a clean, readable structure.
[Insert screenshot of the Format ribbon showing Align and Distribute options with multiple visuals selected on the canvas]
NoteLimit the Number of Visuals Per Page
A report page with too many visuals becomes overwhelming and slow to render. As a general guideline, aim for no more than six to eight visuals on a single page. If your analysis requires more, split the content across additional pages or use drill-through pages for detailed breakdowns. Each page should answer one clear question or serve one clear purpose.
TipUse a Consistent Colour Palette
Colour in a report should be purposeful, not decorative. Use a consistent palette across all pages, ideally aligned with your organization’s brand colours. Apply colour to highlight important values or trends, not just to make the report look varied. Power BI’s Themes feature (covered later in this chapter) makes it easy to apply a consistent palette across all visuals at once.
8.2 Visual Styling and Elements
8.2.1 Report Themes and Consistent Styling
NoteWhat Is a Report Theme?
A theme in Power BI is a collection of formatting settings applied globally across all visuals in a report. It controls default colours, fonts, backgrounds, and visual styles. Applying a theme ensures that every chart, table, and card on every page uses the same visual language, without you having to format each visual individually.
Themes are one of the most effective ways to maintain consistency across a large report and to align a report’s appearance with an organization’s brand guidelines.
NoteApplying a Built-in Theme
To apply a theme:
- Go to the View ribbon in Power BI Desktop
- Click the Themes dropdown. A gallery of built-in themes appears, each previewed as a colour palette strip
- Hover over any theme to see a live preview of how it would look applied to your current report
- Click a theme to apply it. All visuals on all pages update immediately to reflect the new colour scheme and formatting defaults
[Insert screenshot of the Themes gallery dropdown in the View ribbon showing multiple built-in theme options with colour palette previews, and a live preview panel on the right]
NoteCustomizing and Importing Themes
For more control, Power BI allows you to customize the current theme or import a custom theme file:
- In the Themes dropdown, click Customize current theme to open a dialog where you can adjust colours, text, visuals, and page settings manually
- Alternatively, click Browse for themes to import a
.jsontheme file. Custom theme files can be created externally and shared across teams to ensure brand-consistent reporting across all reports in an organization
[Insert screenshot of the Customize Theme dialog showing colour pickers, font selectors, and visual formatting options]
TipApply the Theme Before Building Visuals
Set your report theme as the very first step before placing any visuals on the canvas. Applying a theme after visuals have been individually formatted can override your manual formatting choices, requiring you to redo them. Starting with the theme means all visuals inherit the correct styling automatically from the beginning.
8.2.2 Adding Text Boxes, Images, and Shapes
NoteEnriching the Report with Non-Data Elements
Beyond charts and tables, Power BI allows you to add text boxes, images, and shapes to your report pages. These elements do not display data from the model but serve important design and communication purposes: labelling sections, providing context, displaying logos, and creating visual structure that guides the reader’s eye across the page.
Text Boxes
NoteAdding a Text Box
Text boxes are used for report titles, section headings, descriptive labels, and explanatory notes that give context to the visuals around them.
To add a text box:
- Go to the Insert ribbon and click Text Box
- A text box appears on the canvas. Click inside it and type your content
- Select text inside the box to access formatting options: font family, size, bold, italic, underline, colour, and alignment
- Drag the text box to position it and resize it by dragging its border handles
[Insert screenshot of a text box on the canvas containing a report title, with the text formatting toolbar visible above the text box]
Images
NoteAdding an Image
Images are commonly used to display company logos, product photographs, or icons that give visual identity to a report.
To add an image:
- Go to the Insert ribbon and click Image
- Browse to the image file on your computer (supported formats include PNG, JPG, SVG, and GIF) and click Open
- The image appears on the canvas. Resize and reposition it as needed
- With the image selected, use the Format image options in the Visualizations pane to control how the image scales within its container (Fit, Fill, or Normal)
[Insert screenshot of a report page header area showing a company logo image in the top-left corner alongside a report title text box, creating a branded header bar]
Shapes
NoteAdding Shapes
Shapes are used to create visual structure on the canvas: background panels behind a group of visuals, dividing lines between sections, or decorative borders.
To add a shape:
- Go to the Insert ribbon and click Shapes
- Select a shape type from the menu (Rectangle, Rounded Rectangle, Arrow, Line, Triangle, and others)
- The shape appears on the canvas. Resize and reposition it as needed
- With the shape selected, use the Format shape options in the Visualizations pane to set the fill colour, border colour, border width, and transparency
[Insert screenshot of a report page showing a light-grey rectangle shape used as a background panel behind a group of related KPI card visuals, creating a visually grouped section]
TipUse Shapes as Section Backgrounds
A simple and effective design technique is to place a lightly coloured rectangle behind a group of related visuals to visually bind them together. For example, place a light blue rectangle behind your three KPI cards at the top of the page. This immediately signals to the reader that those cards belong together, without needing a text label to explain the grouping. Send the shape to the back using Format → Send Backward so it does not overlap the visuals placed on top of it.
8.3 Filtering and Slicing Data
8.3.1 Adding and Configuring Slicers
NoteWhat Is a Slicer?
A slicer is a visual filter control that the report consumer interacts with to filter the data displayed across all other visuals on the same report page. Unlike filter panel filters (which are configured by the report builder and may be hidden from users), slicers are visible on the canvas and are designed to be used directly by the reader. Clicking a value in a slicer immediately updates every connected visual on the page to show only the data matching the selected value.
Slicers are one of the most powerful interactivity tools in Power BI and are essential components of almost every well-designed report.
NoteHow to Add a Slicer
- In the Visualizations pane, click the Slicer icon
- A blank slicer placeholder appears on the canvas
- Drag a dimension field (such as Region, ProductCategory, or Year) from the Data pane into the Field well
- The slicer populates with the unique values from that field
[Insert screenshot of a slicer visual on the canvas showing a list of region names (North, South, East, West) with checkboxes next to each, and one region selected and highlighted]
NoteSlicer Display Styles
By default, slicers display as a vertical list. Right-click the slicer and select Slicer settings, or go to the Format visual panel, to change the display style:
- List — a scrollable list of values with checkboxes. Allows multiple selections
- Dropdown — collapses the list into a dropdown menu, saving canvas space. Suitable for slicers with many values
- Between — a range slider for numeric or date fields, letting users select a from/to range
- Before / After — date range controls showing everything before or after a selected date
- Relative date — filters data to a rolling window such as “last 7 days”, “this month”, or “last quarter”
- Tile — displays each value as a clickable button tile, suitable for a small number of categories
[Insert screenshot showing three different slicer styles side by side: a list slicer, a dropdown slicer, and a tile slicer, each filtering by the same field (Year) in different display formats]
TipSync Slicers Across Multiple Pages
By default, a slicer on one page only filters visuals on that same page. If you want a slicer to filter visuals across multiple pages (for example, a Year slicer that applies to every page in the report), use the Sync slicers panel. Go to View → Sync slicers, select the slicer, and then check which pages it should sync to and whether it should be visible on each of those pages.
8.3.2 Using Filters
NoteThe Filters Pane
The Filters pane is a built-in panel on the right side of the Power BI Desktop canvas (and the Power BI service report view) that allows both report builders and, optionally, report consumers to apply filters to data. Filters in the Filters pane operate at three distinct levels, each with a different scope of effect.
[Insert screenshot of the Filters pane open on the right side of the canvas, showing three sections: Filters on this visual, Filters on this page, and Filters on all pages, each with one or more active filter conditions listed]
Visual-Level Filters
NoteFilters on This Visual
Visual-level filters apply to a single selected visual only. They restrict the data shown in that visual without affecting any other visual on the page.
To apply a visual-level filter:
- Click a visual on the canvas to select it
- In the Filters pane, find the Filters on this visual section
- Drag a field from the Data pane into this section, or expand a field that already appears there
- Set the filter condition (such as “is”, “is not”, “is greater than”, “Top N”, etc.) and the filter value
- Click Apply filter
[Insert screenshot of the Filters pane with the “Filters on this visual” section expanded, showing a filter on the Revenue field set to “is greater than 10000”]
Page-Level Filters
NoteFilters on This Page
Page-level filters apply to all visuals on the current report page. They behave like a slicer that is not visible on the canvas: every visual on the page reflects the filter, but no slicer control is shown to the user.
To apply a page-level filter:
- Click on a blank area of the canvas (deselect all visuals)
- In the Filters pane, find the Filters on this page section
- Drag a field into this section and set the condition and value as needed
[Insert screenshot of the Filters pane with the “Filters on this page” section expanded, showing a filter on the Year field set to “is 2025”]
Report-Level Filters
NoteFilters on All Pages
Report-level filters apply to every visual on every page in the entire report. They are used for permanent, global constraints that should always be in effect regardless of which page the user is viewing, such as filtering out test data, restricting the report to a specific business unit, or excluding future-dated records.
To apply a report-level filter:
- Click on a blank area of the canvas
- In the Filters pane, find the Filters on all pages section
- Drag a field into this section and configure the condition
[Insert screenshot of the Filters pane showing the “Filters on all pages” section with a filter on the Status field set to “is not Test”]
TipHide the Filters Pane from Report Consumers
In published reports, you can choose whether the Filters pane is visible to consumers. To hide it, go to File → Options and Settings → Options → Report settings and configure the Filters pane visibility. Alternatively, use the lock icon next to individual filters to prevent consumers from modifying them while still allowing them to see what filters are applied.
8.5 Pulling It All Together
8.5.1 Pulling It All Together
NoteA Report Is More Than a Collection of Charts
A complete Power BI report combines all of the elements covered in this chapter into a coherent, purposeful experience. Pages are organized logically. The layout follows a clear hierarchy. Themes provide consistent styling. Slicers and filters give users control. Text boxes, images, and shapes provide structure and context. Tooltips add depth without clutter. Drill-through pages make detail accessible. Bookmarks and buttons create seamless navigation.
No single element makes a great report on its own. It is the combination of thoughtful data modeling, well-chosen visualizations, and deliberate design that transforms raw data into a report that people trust, return to, and act upon.
ImportantDesign for Your Audience
Every design decision in a report should be made with a specific audience in mind. An executive summary page should communicate the most critical metrics in under ten seconds of reading. An analyst detail page can be denser and more interactive. A report shared with non-technical users should minimize jargon and make slicers and navigation self-explanatory. Always ask: who will use this report, what decision will it support, and what is the simplest way to answer their question clearly?