Formatting for print in Power BI - Dashboard Guide

Dashboard Mode - Formatting for print

Goal

How to format a Power BI report for clear and professional printing.

Sample Data

Product	Region	Sales	Month
Notebook	East	120	January
Pen	West	80	January
Notebook	East	150	February
Pen	West	90	February
Notebook	East	130	March
Pen	West	100	March

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM(Sales[Sales])
  Result: 670
• Bar Chart: Sales by Month
  Shows total sales for each month (January, February, March)
• Table: Sales Details
  Shows Product, Region, Month, and Sales columns
• Page Settings for Print:
  - Page size set to A4
  - Orientation set to Landscape
  - Margins set to Narrow
  - Background color set to White for clear print
  - Font size increased to 12pt for readability
  - Gridlines enabled in table for clarity

Dashboard Layout

+-----------------------------+
|         Total Sales KPI      |
+-----------------------------+
|                             |
|      Sales by Month Chart   |
|                             |
+-----------------------------+
|       Sales Details Table    |
+-----------------------------+

Interactivity

Filters for Region and Month allow users to select specific data. When a filter is applied, the KPI card, bar chart, and table update to show only the filtered data. This ensures the printed report reflects the selected subset clearly.

Self Check

If you add a filter for Region = East, which components update and what changes occur?

• The Total Sales KPI updates to show the sum of sales only for the East region (120 + 150 + 130 = 400).
• The Sales by Month Chart updates to show sales for January, February, and March only for East region.
• The Sales Details Table shows only rows where Region is East.

Key Result

A Power BI report formatted for print showing total sales, monthly sales chart, and detailed sales table with print-friendly settings.