Ravindra BagaleCourses & study guides मराठी Track your progress

Ravi Sir's Cards › Power BI

22. Filters and Slicers: Cards

मराठी cards · Open the chapter

Revision cards

The Filters pane and its levels. Filters in the wrong level give wrong numbers on other visuals or pages.
Revision card 1 of 12: The Filters pane and its levels · Download PNG · Open card page

Lesson: 22.1 The Filters Pane and Its Levels

Basic and advanced filtering. Ticking boxes is not enough for rules like “contains” or “greater than”.
Revision card 2 of 12: Basic and advanced filtering · Download PNG · Open card page

Lesson: 22.2 Basic and Advanced Filtering

Measure filters (visual level). Sometimes you want to hide items by a result, not by a value in a column.
Revision card 3 of 12: Measure filters (visual level) · Download PNG · Open card page

Lesson: 22.3 Measure Filters (Visual Level)

Top N filter. Long lists hide the most important items.
Revision card 4 of 12: Top N filter · Download PNG · Open card page

Lesson: 22.4 Top N Filter

Relative date and relative time filters. Fixed date filters go out of date every day.
Revision card 5 of 12: Relative date and relative time filters · Download PNG · Open card page

Lesson: 22.5 Relative Date and Relative Time Filters

Locking, hiding, renaming and formatting filters. Some filters are rules of the report, not user choices.
Revision card 6 of 12: Locking, hiding, renaming and formatting filters · Download PNG · Open card page

Lesson: 22.6 Locking, Hiding, Renaming and Formatting Filters

Slicers: styles and settings. Good slicer settings make filtering quick and clear.
Revision card 7 of 12: Slicers: styles and settings · Download PNG · Open card page

Lesson: 22.7 Slicers: Styles and Settings

Clearing selections. Users get lost after many clicks.
Revision card 8 of 12: Clearing selections · Download PNG · Open card page

Lesson: 22.8 Clearing Selections

Sync slicers across pages. Users expect a City choice to follow them to other pages.
Revision card 9 of 12: Sync slicers across pages · Download PNG · Open card page

Lesson: 22.9 Sync Slicers Across Pages

Edit interactions: filter, highlight, none. Some visuals should not change when users click another visual.
Revision card 10 of 12: Edit interactions: filter, highlight, none · Download PNG · Open card page

Lesson: 22.10 Edit Interactions: Filter, Highlight, None

Slicer vs filter: when to use which. Too many slicers crowd the page; hidden filters confuse users.
Revision card 11 of 12: Slicer vs filter: when to use which · Download PNG · Open card page

Lesson: 22.11 Slicer vs Filter: When to Use Which

How all filters combine. Numbers look wrong when you forget a filter at another level.
Revision card 12 of 12: How all filters combine · Download PNG · Open card page

Lesson: 22.12 How All Filters Combine

Interview cards

How do you stop a card from changing when users click a chart? Use Edit interactions. Select the chart, open Format > Edit interactions, and choose None on the card.
Interview card 1 of 2: How do you stop a card from changing when users click a chart? · Download PNG · Open card page

Lesson: 22.10 Edit Interactions: Filter, Highlight, None

Can you filter a page by a measure? No. A measure filter works only at visual level, because the measure is calculated for each item in that visual.
Interview card 2 of 2: Can you filter a page by a measure? · Download PNG · Open card page

Lesson: 22.3 Measure Filters (Visual Level)

Comparison cards

Filter vs highlight interaction. Both are ways a selected visual changes other visuals.
Comparison card 1 of 1: Filter vs highlight interaction · Download PNG · Open card page

Lesson: 22.10 Edit Interactions: Filter, Highlight, None