Siksha Sarovar

Siksha Sarovar (sikshasarovar.com) is a free educational web application that helps students in India learn programming and prepare for academic and competitive exams. The platform offers structured coding courses (C, C++, Python, Java, HTML, CSS, PHP, Power BI, AI, Machine Learning, Data Science), complete university curriculum notes for BCA/MCA students with previous year question papers, Class 10 and Class 12 CBSE/HBSE school notes, and dedicated preparation material for SSC, UPSC, Banking, Railway and other government exams. Browsing the site is completely free and requires no account. Users may optionally sign in with Google solely to save their learning progress, quiz scores and personal preferences across devices.

Privacy Policy | Terms of Service | Contact Siksha Sarovar | About Siksha Sarovar

v4.0.9 · PWA
Siksha Sarovar logo
Siksha Sarovar
Your Learning Universe

Siksha Sarovar is a free e-learning platform for coding courses, BCA university notes and competitive exam preparation. Optional Google sign-in saves your learning progress across devices.

Initializing knowledge base…
Compiling modules 0%

4.7 Using Slicers & Syncing Across Pages

Lesson 38 of 62 in the free Power BI notes on Siksha Sarovar, written by Rohit Jangra.

Using Slicers in Power BI

Slicers are visual filters placed directly on the report canvas. They provide an intuitive, user-friendly way to filter data interactively.

What is a Slicer?

A slicer is a standalone visual that filters other visuals on the page. Unlike the filter pane, slicers are visible and interactive on the canvas.

Types of Slicers

Slicer TypeBest ForDescription
List SlicerCategories, text valuesDisplays a list of values with checkboxes
Dropdown SlicerSaving spaceCompact dropdown selection
Date SlicerDate rangesCalendar or slider for date selection
Numeric Range SlicerNumber rangesSlider to set min/max values
Relative Date SlicerDynamic dates"Last 7 days", "Last month", etc.
Tile SlicerVisual categoriesButton-style tiles
Image SlicerVisual selectionUses images as slicer options

Creating a Slicer

Steps:

  1. Click an empty area on the canvas
  2. In Visualizations pane → Select the Slicer visual
  3. Drag a field from the Fields pane into the slicer
  4. Configure the slicer style:
  • Click the Format icon → Slicer settings → Choose: List, Dropdown, or Tile

Date Slicer Configuration

Date slicer styles:Between — slider to select a date range • Before — show data before a selected date • After — show data after a selected date • List — show dates as checkboxes • Dropdown — compact date list • Relative Date — "Last N days/weeks/months" (dynamically updates)

Multi-Select Options

Single Select: • Click one item at a time (Ctrl+Click for multiple) • Enable in Format → Selection → Single Select: On

Select All: • Add a "Select All" option at the top • Format → Selection → Show "Select All" option: On

Syncing Slicers Across Pages

By default, a slicer only affects the page it's on. You can sync slicers so they affect multiple pages.

Steps to Sync Slicers:

  1. Select the slicer
  2. Go to ViewSync slicers (opens the sync pane)
  3. For each page, configure two options:
  • Sync (🔗): Should this page respond to the slicer?
  • Visible (👁️): Should the slicer be visible on this page?

Sync Configurations:

ConfigSync?Visible?Effect
Sync + VisibleSlicer appears and filters on this page
Sync + HiddenSlicer filters this page but isn't shown
No Sync + VisibleSlicer appears but doesn't filter this page
No Sync + HiddenSlicer has no effect on this page

Advanced Sync Groups: • Create named sync groups to link specific slicers together • Useful when multiple slicers control different dimensions across pages

Best Practices for Slicers

• Use dropdown slicers to save canvas space • Use relative date slicers for time-sensitive dashboards • Sync important slicers (like Date) across all pages • Limit to 3-5 slicers per page to avoid overwhelming users • Place slicers in a consistent location (top or left side) • Use horizontal slicers for fewer options, vertical for many • Set default selections to show the most relevant data initially