Master Power BI From Scratch

Learn Power BI fundamentals, data sources, data transformation, data modeling, DAX, visualizations, reports, and dashboards through structured practical lessons.

COURSE SYLLABUS
1. Power BI Introduction
Introduction to Power BI Power BI Desktop and Service Power BI Workflow Power BI Terminology Power BI Workspace Overview
2. Power BI Installation and Interface
Power BI Installation Power BI Desktop Interface Report, Data and Model Views Power BI File Management Power BI Settings and Options
3. Power BI Data Sources
Excel and CSV Data Sources Text and Folder Data Sources Database Data Sources Web and Online Data Sources Data Source Credentials and Refresh
4. Power BI Data Transformation
Power Query Introduction Data Types and Column Operations Merge and Append Queries Split, Group and Pivot Columns Power Query Applied Steps
5. Power BI Data Cleaning
Missing and Null Values Remove Duplicates and Errors Text and Date Cleaning Replace and Fill Values Data Quality Validation
6. Power BI Data Modeling
Data Modeling Fundamentals Create Table Relationships Cardinality and Filter Direction Star Schema and Dimension Tables Date Tables and Model Optimization
7. DAX
DAX Introduction and Syntax DAX Aggregation Functions DAX Logical and Conditional Functions DAX Filter and Iterator Functions DAX Date and Time Intelligence
8. Power BI Calculations
Calculated Columns Measures and Implicit Measures Row Context and Filter Context Quick Measures and KPI Time-Based Business Calculations
9. Power BI Visualizations
Basic Power BI Charts Pie, Donut and Treemap Charts Cards, Tables and Matrices Maps and Geographic Visuals Advanced and Custom Visuals
10. Power BI Filters and Slicers
Filter Types and Filter Pane Slicers and Sync Slicers Drill Down and Drill Through Cross-Filtering and Highlighting Bookmarks and Buttons
11. Power BI Reports and Dashboards
Report Page Layout and Design Multi-Page Reports Dashboard Creation and Tiles Executive and Business Reports Report Usability and Accessibility
12. Power BI Formatting and Interactivity
Themes and Color Formatting Conditional Formatting Tooltips and Report Page Tooltips Visual Interactions and Edit Interactions Mobile Layout and Responsive Reports
13. Power BI Publishing and Sharing
Publish Reports to Service Workspaces and Apps Scheduled Refresh and Gateway Sharing and Permissions Row-Level Security and Deployment
14. Power BI Projects and Assessment
Sales Dashboard Project Student Performance Project Data Cleaning and Modeling Assignment DAX and Visualization Assessment Final Power BI Project and Assessment

Slicers and Sync Slicers

Slicers are interactive visual controls that allow report users to filter data directly on the report canvas. Instead of opening the filter pane, users can select a year, region, product, category, or another field and immediately explore the relevant information.

Learning Objectives

  • Understand slicers and their purpose in a Power BI report.
  • Create slicers using categorical and date fields.
  • Configure list, dropdown, and date slicers.
  • Control which visuals respond to a slicer.
  • Synchronize slicers across multiple report pages.

1. What Is a Slicer?

A slicer is a visual filter placed directly on a report page. It gives users a simple way to select values and filter connected report visuals. Slicers are especially useful when reports are designed for interactive business analysis.

How a Slicer Works

Region ✓ North □ South □ East □ West Sales by Month Jan Feb Mar Apr Selected Region North Updated results

Selecting a region filters the connected chart and other affected visuals to show information for that selection.

2. Create Your First Slicer

Assume a sales table contains the columns OrderDate, Region, Product, and SalesAmount. You can create a slicer that allows users to select a region.

Steps to Create a Region Slicer

  1. Open your report in Power BI Desktop.
  2. Select an empty area of the report canvas.
  3. Choose the Slicer visual from the Visualizations pane.
  4. Drag the Region field into the slicer's field well.
  5. Resize and position the slicer on the report page.
  6. Select a region and observe how connected visuals respond.
Tip: Add a clear title such as "Select Region" so users understand what the slicer controls.

3. Common Slicer Types

Slicer Type Purpose Example
List Displays values in a visible list. North, South, East, West
Dropdown Saves report space by showing values in a compact menu. Choose a product category.
Date or range slicer Allows selection of dates or a date interval. Orders between January and March.
Numeric range slicer Filters numeric values within a range. Sales amounts from 1,000 to 5,000.
Hierarchy slicer Allows users to navigate related levels when supported by the visual and field setup. Year, quarter, and month.

List and Dropdown Examples

List Slicer ✓ Electronics □ Furniture □ Clothing □ Accessories Dropdown Slicer Electronics Furniture Clothing Accessories

List slicers make options visible, while dropdown slicers are useful when report space is limited or the field contains many values.

4. Single Selection and Multiple Selection

Slicer selection settings determine whether users can choose one value or several values at a time. Available options depend on the slicer type and the Power BI version.

Selection Mode Behavior Suitable Use
Single selection Allows one value to be selected at a time. Select one reporting year.
Multiple selection Allows several values to be selected. Compare multiple regions.
Select all Provides an option to include all available values. Return to an overall view.

Selection Behavior

Single Selection 2024 2025 2026 One year is selected. Multiple Selection North South East Two regions are selected.

5. Format a Slicer

Formatting helps users understand how to interact with a slicer. Depending on the visual and current Power BI interface, formatting options may include the title, header, values, selection controls, background, border, and layout.

Recommended Formatting Steps

  1. Select the slicer on the report canvas.
  2. Open the Format visual pane.
  3. Enable and edit the title where appropriate.
  4. Adjust text size and spacing for readability.
  5. Use a consistent background and border style.
  6. Test the slicer at normal report viewing size.
Design Tip: Keep slicer labels short and consistent. Place related slicers together so users can find filters quickly.

6. Control Which Visuals a Slicer Affects

By default, a slicer generally filters other visuals on the same page that are connected to the selected data. You can customize its interactions when some visuals should remain unchanged.

Use Edit Interactions

  1. Select the slicer that will control the report.
  2. Open the Format ribbon and choose Edit interactions.
  3. Review the interaction controls shown on other visuals.
  4. Choose the appropriate filter, highlight, or no-interaction option where available.
  5. Exit Edit interactions and test the report.

Interaction Concept

Region Slicer ✓ North □ South Sales Chart Filtered by North Company Logo No interaction

A report designer can allow a slicer to filter the sales chart while preventing it from affecting a separate visual, such as a logo or an intentionally fixed reference indicator.

7. What Are Sync Slicers?

Sync slicers allow a slicer selection to be shared across multiple report pages. This is useful when users move between pages but need the same region, year, or category selection to remain active.

For example, a report may have a Sales Overview page, a Product Analysis page, and a Regional Performance page. A synchronized Region slicer can keep the selected region consistent as users navigate between these pages.

How Slicer Synchronization Works

Region Slicer Selected: North Sync enabled Sales Overview North selected Product Analysis North selected Regional Details North selected

8. Synchronize a Slicer Across Pages

Step-by-Step Instructions

  1. Create a slicer on the report page where it will first be used.
  2. Select the slicer.
  3. Open the View ribbon and choose Sync slicers.
  4. Review the pages listed in the Sync slicers pane.
  5. Enable synchronization for the pages that should share the selection.
  6. Use the visibility controls to decide where the slicer itself should appear, where available.
  7. Test the selection by switching between report pages.
Important: Synchronizing a slicer and displaying it on a page are different settings. Depending on the configuration, a page may use the synchronized selection without showing the slicer itself. Test the report from the user's perspective before publishing.

9. Practical Business Example

Consider a sales report used by management at CIIT TRANING INSTITUTE. The report contains sales totals, product performance, and regional results. The goal is to allow users to filter these pages by year and region without repeatedly making the same selections.

Report Page Visuals Slicer Configuration
Sales Overview Total Sales card and monthly sales chart Year and Region slicers
Product Analysis Product sales chart and category table Sync Year and Region selections
Regional Performance Regional comparison chart Sync Year and Region selections
Best Practice: Synchronize only the slicers that should remain consistent across pages. Different pages may need their own independent filters for specialized analysis.

10. Common Slicer Problems

Problem Possible Cause What to Check
A visual does not change The interaction is disabled or the data model does not support the expected filtering. Review Edit interactions, relationships, and field usage.
A selection does not appear on another page The slicer is not synchronized with that page. Review the Sync slicers pane.
The slicer uses too much space A long list is displayed directly on the canvas. Consider a dropdown slicer or a more compact layout.
Users cannot easily clear a selection The reset or clear-selection behavior is not obvious. Check available slicer controls and provide clear report instructions.
The report opens with an unexpected selection A saved report state or bookmark may preserve a previous selection. Review the saved report state and relevant bookmarks.

11. Hands-On Practice

Practice Task 1: Create a Region Slicer

  1. Open a sales report containing a Region field.
  2. Add a slicer and place Region in its field well.
  3. Choose North and observe the changes in your charts.
  4. Choose another region and compare the results.

Practice Task 2: Create a Year Slicer

  1. Add a slicer using the appropriate year field from your date data.
  2. Configure its appearance to fit the report page.
  3. Select one year and compare the sales totals.
  4. Clear the selection and verify that the overall view returns.

Practice Task 3: Sync Slicers

  1. Create a second report page called Product Analysis.
  2. Open the Sync slicers pane.
  3. Synchronize the Region slicer across both pages.
  4. Change the region on one page and check the other page.
  5. Test whether the slicer should be visible on both pages.

12. Knowledge Check

Question 1: What is the main purpose of a slicer?

A. To write DAX formulas

B. To let users filter report data interactively

C. To create a database table

D. To publish a report automatically


Question 2: Which slicer style is useful when you need to save space?

A. Dropdown

B. A large list with every value visible

C. A text box with no field

D. A report title


Question 3: What is the purpose of Sync slicers?

A. To synchronize selections across selected report pages

B. To merge two tables

C. To change the data type of a column

D. To create a calculated column


Question 4: Where can you review which pages share a slicer selection?

A. The Sync slicers pane

B. The DAX formula bar

C. The database connection dialog only

D. The Windows desktop

Show Answers
  1. B — Slicers let users filter report data interactively.
  2. A — Dropdown slicers use less visible canvas space.
  3. A — Sync slicers share selections across configured report pages.
  4. A — The Sync slicers pane controls page synchronization and visibility.

Summary

Slicers make Power BI reports interactive by allowing users to filter data directly on the report canvas. They can display lists, dropdowns, date ranges, and other supported selection controls.

  • Create slicers by adding a field to a Slicer visual.
  • Choose suitable selection and formatting options for your audience.
  • Use Edit interactions to control how a slicer affects other visuals.
  • Use Sync slicers to share selections across selected report pages.
  • Test slicer behavior and saved selections before publishing a report.

In the next lesson, you will learn how to use drill-down and drill-through features to explore data at different levels of detail.