22. Filters and Slicers
Filters aani slicers sagalya report madhe astat, pan te ekmekanshi kase kaam kartat he khup students la mahit nasta. Ya module madhe filter levels, Top N, relative date, slicer settings, sync slicers aani edit interactions ekdum clear karu.
What you will learn in this module
- The Filters pane: visual, page, all pages and drill-through levels
- Filter types: basic, advanced, Top N, relative date, relative time, measure filters
- Locking, hiding, renaming filters and formatting the Filters pane
- Slicer styles: list, dropdown, tile, between/range, relative date, hierarchy, button and list slicers
- Selection options (single select, Select all), clearing selections
- Sync slicers across pages and Edit interactions (filter/highlight/none)
- Slicer vs filter: when to use which
Live story: Why is my card blank?
Suppose the Nashik manager opens the report and the Sales card is blank. A page filter, a slicer and a visual filter are all active at once. Each one removed some rows. Together they removed all rows. This chapter explains every filter level and how they combine (AND across, OR inside one slicer).
All numbers in this story are fictional practice data.
Live story: माझा card blank का आहे?
समजा Nashik चे manager report उघडतात आणि Sales card blank आहे. एक page filter, एक slicer आणि एक visual filter एकाच वेळी चालू आहेत. प्रत्येकाने काही rows काढल्या. सगळ्यांनी मिळून सगळ्या rows काढल्या. हा chapter प्रत्येक filter level आणि ते कसे जोडले जातात (वेगवेगळ्या filters मध्ये AND, एका slicer च्या आत OR) हे समजावतो.
या story मधले सगळे आकडे काल्पनिक practice data आहेत.
Live story: मेरा card blank क्यों है?
मान लीजिए Nashik के manager report खोलते हैं और Sales card blank है. एक page filter, एक slicer और एक visual filter एक साथ चालू हैं. हर एक ने कुछ rows हटाईं. सबने मिलकर सारी rows हटा दीं. यह chapter हर filter level और वे कैसे जुड़ते हैं (अलग-अलग filters में AND, एक slicer के अंदर OR) समझाता है.
इस story के सारे आँकड़े काल्पनिक practice data हैं.
Concepts in this chapter
- 22.1The Filters Pane and Its Levels
- 22.2Basic and Advanced Filtering
- 22.3Measure Filters (Visual Level)
- 22.4Top N Filter
- 22.5Relative Date and Relative Time Filters
- 22.6Locking, Hiding, Renaming and Formatting Filters
- 22.7Slicers: Styles and Settings
- 22.8Clearing Selections
- 22.9Sync Slicers Across Pages
- 22.10Edit Interactions: Filter, Highlight, None
- 22.11Slicer vs Filter: When to Use Which
- 22.12How All Filters Combine
Review and practice
The chapter recap is at the end of the last concept page.
Ravi Sir's Cards: 15 revision, interview and comparison cards for this chapter · मराठी cards