Launch Deal · 50% off 1st month ·

3.1 — Select, Format and Theme Visuals

PL-300 Domain 3 · Skill 3.1

What You Need to Know

Choosing the right visual

Start from the question the visual must answer.

Question Visual
Compare categories Clustered bar (long category names) or clustered column
Trend over time Line chart or area chart (continuous date axis)
Trend plus a second measure on another scale Line and clustered column combo chart, with a secondary axis
Parts of a whole, few categories Stacked bar/column, 100% stacked, donut or pie (2–5 slices at most)
Hierarchical parts of a whole Treemap
How a starting value becomes an ending value Waterfall
Stages that narrow down (sales pipeline) Funnel
Relationship between two measures Scatter chart (add size for a bubble chart, a play axis for animation over time)
Ranking changes over time Ribbon chart
One key number Card or New card (several values in one visual)
A number against a target KPI (with trend) or Gauge
Exact values, cross-tab Table, or Matrix (rows, columns, subtotals, drill-down)
Location Map, Filled map, Azure Maps, Shape map
Explain why a value changed AI visuals (lesson 3.8)

AppSource and organizational custom visuals extend the list. Admins can restrict them to certified or organizational visuals.

Formatting and configuring

The Format visual pane has Visual settings (axes, data labels, legend, markers, gridlines, colors) and General settings (title, subtitle, effects, header icons, alt text, size and position).

  • Titles can use a measure (fx button) so they change with the filters ("Sales for 2026").
  • Small multiples split one chart into a grid by a category.
  • Format painter copies formatting from one visual to another.
  • Number formats come from the model (lesson 2.1) and can be overridden per visual.

Themes

A report theme sets colors, fonts and visual defaults for the whole report.

  • View > Themes: pick a built-in theme, Browse for themes to import a JSON theme file, or Customize current theme (name and colors, text, visuals, page, filter pane).
  • Save current theme exports it as JSON so other reports can use the same branding.
  • A theme's data colors drive series colors. A color set manually on a visual overrides the theme for that visual.
  • Accessible themes with enough contrast are built in (lesson 3.7).

Key Concept: Pick the visual from the question (compare, trend, part-to-whole, relationship, single number, detail), then format it consistently through a JSON theme instead of editing every visual by hand.

Exam Traps

  • A pie chart with 15 slices (use a bar chart)
  • A line chart over a categorical axis that isn't time
  • Formatting every visual's colors manually when a theme is required for consistency across reports
  • Using a table where a matrix with subtotals and drill-down is needed
  • Choosing a gauge when the requirement also asks for the trend (a KPI visual shows both)

Check your understanding

Practice Scenario

🔒 This practice scenario is part of Skillmarked Pro

The lessons stay free. Pro unlocks the other 22 PL-300 practice scenarios and the 50-question timed mock exam, plus everything for every other exam.

See plans

Launch Deal: first month €9.95, then €19.90/month. Enter code LAUNCH50 at checkout. Ends 1 December.

Cancel anytime. Or €199 a year, which saves 17%.

Not sure yet? Try 10 free mock exam questions.

Already Pro? Log in.