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.
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.
Sources
- Visualization types in Power BI, Microsoft Learn
- Use report themes in Power BI Desktop, Microsoft Learn
- Get started formatting Power BI report visualizations, Microsoft Learn
- Small multiples in Power BI, Microsoft Learn