Page layout and canvas settings in Power BI - Dashboard Guide

Dashboard Mode - Page layout and canvas settings

Dashboard Goal

Understand how to set up the page layout and canvas size in Power BI to create a clear and well-organized report.

Sample Data

Month	Sales	Region
January	100	North
February	150	South
March	200	East
April	130	West
May	170	North
June	220	South

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM(Sales[Sales])
  Result: 970
• Bar Chart: Sales by Month
  Shows sales values for each month from January to June.
• Page Size Setting: Canvas set to 16:9 aspect ratio (1280x720 pixels) for widescreen display.
• Page View Setting: Set to 'Fit to page' to see the entire report page without scrolling.
• Canvas Background Color: Light gray (#f5f5f5) to reduce eye strain and improve readability.

Dashboard Layout

+--------------------------------------------------+
|                   Total Sales (KPI)              |
|                      [970]                       |
+----------------------+---------------------------+
|  Sales by Month Bar Chart (wide)                 |
|  Jan | Feb | Mar | Apr | May | Jun                |
|  100 | 150 | 200 | 130 | 170 | 220                |
+--------------------------------------------------+

Canvas size: 1280x720 pixels (16:9 aspect ratio)
Page view: Fit to page
Background color: Light gray (#f5f5f5)

Interactivity

Currently, no slicers or filters are added. The page layout and canvas settings affect how all visuals appear together on the screen. Changing the page size or view mode resizes or fits all components accordingly.

Self Check

If you change the page size from 16:9 to 4:3, how will the bar chart and KPI card adjust on the canvas?

Answer: The visuals will resize to fit the new canvas size, possibly changing their width and height to maintain visibility without scrolling.

Key Result

A simple Power BI report showing total sales and sales by month with page layout set to 16:9 canvas and fit to page view.