Advanced Formatting in Power BI

Audience:

Report authors and analysts who are comfortable building visuals, measures and basic models in Power BI Desktop, and who want their dashboards to be clearer, more consistent and more polished. This course is ideal for professionals who want to Master advanced Power BI formatting for truly interactive, dynamic and engaging dashboards.

Duration:

1 Days

Delivery:

Virtual (2 half day) or in-person (1 full day). Delivered live-virtual across Canada and the US, and in-person in Ottawa–Gatineau (National Capital Region). On-site delivery available for Government of Canada and private-sector teams.

Next public sessions (live-virtual, 2 half-days, $700/person): Nov 3–4 & Dec 15–16, 2026 · Jan 26–27 & Feb 17–18, 2027 — book on our training page.

Course description:

A report can be accurate and still be hard to read. This course shows you how to go beyond the Format pane defaults and build reports that look and read like finished, professional products.

You'll learn number formats that adapt to the data, colour and icons driven by rules and measures, titles and tooltips that narrate the numbers, and report-wide branding that holds together on every page. Every technique is demonstrated live, with commented measures and DAX patterns you can cuse immediately

Course overview:

Module 1: Formatting Fundamentals

• Data types and formats that display correctly by default

• Custom number format strings: thousands, millions, padded codes, cents

• Dynamic number formats that switch between $, K and M as the data scales

• Percentages and positive/negative variances

Module 2: Conditional and Rule-Based Formatting

• Background and font colour rules, driven by thresholds or by a field value

• Icon sets from numeric thresholds and text conditions

• Gradient heat-maps with sequential and diverging scales

• Actual vs target with status colours and icons

• Line charts: threshold-coloured markers and legends that fade by recency

Module 3: Narrating the Data

• Advanced tooltips that explain a data point on hover

• Dynamic titles that respond to slicers and selections

• Narrative summary text built with DAX, and when to use it instead of Smart Narrative

Module 4: Calculations Behind Formatting

• Colour logic defined in measures, with a central palette

• Visual calculations vs DAX: where each is the better tool

• Custom total rows, and when a total needs its own logic

• Format strings as measures

• A two-measure technique for changing a line's colour

Module 5: Interactivity as Formatting

• Field parameters to switch fields and bin widths

• Bookmark-driven navigation and a hidden filter panel that keeps its selections

• A values toggle to switch measures

• Drill-through pages that feel part of the report

Module 6: Report-Wide Branding

• Reading and editing theme JSON, and what a theme does and doesn't control

• Live theme swapping to see which parts of a report re-skin

• A reusable template page with header and footer bands and a filter rail

• Design-system thinking, including a look at Fluent 2

By the end of this course, participants will be able to:

• Format numbers, dates and codes precisely, including formats that adapt to the value

• Drive colour, icons and gradients from rules, field values and measures

• Add titles, tooltips and narrative text that tell the reader what matters

• Choose the right calculation approach (DAX or visual calculation) for formatting logic

• Use field parameters, bookmarks and drill-through to build clean, self-serve reports

• Apply a consistent theme and page template across a whole report