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.
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
- Apply conditional table formatting in Power BI, Microsoft Learn
- Slicers in Power BI, Microsoft Learn
- Add a filter to a report in Power BI, Microsoft Learn
- Format filters in Power BI reports, Microsoft Learn