Launch Deal · 50% off 1st month ·

3.2 — Conditional Formatting, Slicing and Filtering

PL-300 Domain 3 · Skill 3.2

What You Need to Know

Conditional formatting

Available on tables, matrices, cards, charts' colors and titles. In a table or matrix: Format > Cell elements, or right-click a field in the Values well > Conditional formatting.

Type Effect
Background color / Font color Color each cell
Data bars A bar inside the cell, proportional to the value
Icons Arrows, traffic lights, flags
Web URL Makes the cell a link

Each can be driven by:

  • Gradient (color scale): lowest to highest value, with an optional middle color
  • Rules: if value ≥ x and < y then this color (numbers or percentages)
  • Field value: a column or measure that returns the color itself, such as IF([Margin %] < 0.1, "#C0392B", "#2E8B57"). Use this for logic that rules can't express

Formatting can be based on a different field than the one displayed, for example coloring Sales by Margin %.

Slicers

Slicer style Use
Vertical list / Tile / Dropdown Pick categories; single select or multi-select, optional Select all
Between (numeric/date range) A slider with two ends
Relative date Last 7 days, this month, next 3 quarters
Button slicer and Text slicer Newer slicer types: button-style choices, or free-text search
Hierarchy slicer Drill from year into months, or from category to product

Slicers filter every visual on the page that interacts with them (lesson 3.6). Sync slicers carry them across pages.

The Filters pane

Level Applies to
Visual-level One visual
Page-level Every visual on the page
Report-level Every page
Drillthrough The drillthrough target page (lesson 3.6)

Filter types: Basic (pick values), Advanced (contains, starts with, is blank, and/or conditions), Top N (top 10 products by a measure, visual level only), and Relative date/time.

Report authors can:

  • Lock a filter so readers can't change it
  • Hide a filter so readers don't see it (the filter still applies)
  • Format or hide the whole Filters pane (Format > Filter pane)
  • Rename filter cards to friendly names

Filters and slicers are not security. Anyone with Build permission or Analyze in Excel can still see the data. Use RLS (lesson 4.6).

Key Concept: Slicers are on-canvas filters for readers. The Filters pane adds visual, page and report scope, Top N and advanced conditions. Conditional formatting by field value handles any rule you can write in DAX.

Exam Traps

  • Using a page-level filter when only one visual should be affected
  • Applying Top N at page level (it's a visual-level filter type)
  • Hiding a filter to "secure" data
  • Building separate visuals per color band instead of conditional formatting
  • Choosing gradient formatting when the requirement names exact thresholds (use rules)

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.