Formatting for print in Power BI - Real Business Scenario

Scenario Mode

👤 Your Role: You are a business analyst at a retail company.

📋 Request: Your manager wants a monthly sales report that can be printed and shared in meetings. The report should be easy to read on paper with clear titles, consistent fonts, and no unnecessary colors or backgrounds.

📊 Data: You have sales data by month, region, and product category with sales amounts and quantities.

🎯 Deliverable: Create a Power BI report formatted specifically for printing. It should have a clean layout, readable fonts, proper page size, and no distracting colors or visuals that do not print well.

Sample Data

Month	Region	Category	Sales Amount	Quantity Sold
January	North	Electronics	12000	150
January	South	Furniture	8000	80
February	North	Electronics	15000	170
February	East	Furniture	7000	75
March	South	Electronics	13000	160
March	East	Furniture	9000	90
April	North	Electronics	14000	155
April	South	Furniture	8500	85

1

Step 1: Set the report page size to 'Letter' for standard printing.

In Power BI Desktop, go to 'Format' pane > 'Page size' > select 'Letter' (8.5 x 11 inches).

Expected Result

Report page size is set to Letter, suitable for printing on standard paper.

2

Step 2: Remove background colors and images from the report pages.

In 'Format' pane > 'Page background' > set 'Image' to None and 'Color' to white with 0% transparency.

Expected Result

Report background is plain white with no images, ensuring clean print output.

3

Step 3: Use simple, readable fonts for all text elements.

Select all text visuals and titles > set font family to 'Arial' or 'Calibri' and font size to 12-14 pt.

Expected Result

All text is clear and easy to read on printed pages.

4

Step 4: Adjust visual colors to grayscale or black and white for printing.

Change chart colors to shades of gray or black and white by editing data colors in each visual.

Expected Result

Visuals print clearly without color confusion or loss of information.

5

Step 5: Add page headers and footers with report title and page numbers.

Use text boxes at top and bottom of the page: top with report title, bottom with page number using 'Page number' visual or manually.

Expected Result

Printed pages have clear titles and page numbers for easy navigation.

6

Step 6: Preview the report in 'Print Layout' mode and adjust margins if needed.

In Power BI Desktop, use 'File' > 'Print' > 'Print Preview' to check layout and margins.

Expected Result

Report fits well on pages with no cut-off content.

7

Step 7: Export the report to PDF for printing.

Use 'File' > 'Export' > 'Export to PDF' to create a print-ready file.

Expected Result

A clean, print-ready PDF report is generated.

Final Result

-----------------------------------------
|           Monthly Sales Report         |
|---------------------------------------|
| Month | Region | Category  | Sales ($) |
|---------------------------------------|
| Jan   | North  | Electronics| 12,000   |
| Jan   | South  | Furniture  | 8,000    |
| Feb   | North  | Electronics| 15,000   |
| Feb   | East   | Furniture  | 7,000    |
| Mar   | South  | Electronics| 13,000   |
| Mar   | East   | Furniture  | 9,000    |
| Apr   | North  | Electronics| 14,000   |
| Apr   | South  | Furniture  | 8,500    |
|---------------------------------------|
| Page 1                                |
-----------------------------------------

✓The report is formatted with clear fonts and no background colors for easy printing.

✓Charts and tables use grayscale colors to maintain clarity in black and white prints.

✓Page size and margins are set to standard Letter size to avoid content cut-off.

✓Headers and footers provide context and page numbers for printed copies.

Bonus Challenge

Create a custom print-friendly theme in Power BI that automatically applies all formatting settings for print.

Show Hint

Use Power BI Desktop's JSON theme file to define font styles, colors, and page settings, then import it to apply consistently.