Scribd
Upload
5 views23 pages

Chapter4 Filtering

The document introduces key features of Power BI, focusing on drilling down and filtering data for better visualization. It explains how to display data at various levels of detail and the types of filters available, including visual-level, page-level, and report-level filters. Additionally, it covers the importance of controlling user interactions with filters in reports.

Uploaded by

mohamedamine5dz
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views23 pages

Chapter4 Filtering

The document introduces key features of Power BI, focusing on drilling down and filtering data for better visualization. It explains how to display data at various levels of detail and the types of filters available, including visual-level, page-level, and report-level filters. Additionally, it covers the importance of controlling user interactions with filters in reports.

Uploaded by

mohamedamine5dz
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Drilling down and

filtering
INTRODUCTION TO POWER BI

Sara Billen
Senior Data Analyst, DataCamp
Drilling down

Show data at a high level

Option to show a more detailed level

INTRODUCTION TO POWER BI
Hierarchies
Example 1 Example 2

INTRODUCTION TO POWER BI
Drilling down on a visual

INTRODUCTION TO POWER BI
Drill down all fields at once

INTRODUCTION TO POWER BI
Drill down all fields at once

INTRODUCTION TO POWER BI
Drill down all fields at once

INTRODUCTION TO POWER BI
Expand all fields at once

INTRODUCTION TO POWER BI
Expand all fields at once

INTRODUCTION TO POWER BI
Expand all fields at once

INTRODUCTION TO POWER BI
Expand all fields at once

INTRODUCTION TO POWER BI
Filtering
Display data based on some selected
criteria

Examples:
Filter on one year or one customer

Show the top 5 regions

Types of filters in Power BI:


Visual-level filters

Page-level filters

Report-level filters

INTRODUCTION TO POWER BI
Turning off filtering
Don't allow the end-user of your report to change the filters
In Power BI: turning off interactions
Visual will not change when another field is selected

INTRODUCTION TO POWER BI
Let's practice!
INTRODUCTION TO POWER BI
The underlying data
and hierarchies
INTRODUCTION TO POWER BI

Sara Billen
Curriculum Manager, DataCamp
Let's practice!
INTRODUCTION TO POWER BI
Filters
INTRODUCTION TO POWER BI

Sara Billen
Senior Data Analyst, DataCamp
Let's practice!
INTRODUCTION TO POWER BI
Congratulations!
INTRODUCTION TO POWER BI

Iason Prassides
Curriculum Manager, DataCamp
Getting Started with Power BI
Table, Model, and Report view
Loading multiple datasets

Building a data model

First interactive report

Power Query Editor

INTRODUCTION TO POWER BI
Visualizing data
Different types of visualization
Hierarchies

Drill-down paths

Sorting

Filtering

Controlling interactivity

INTRODUCTION TO POWER BI
Data Analyst in Power BI track

INTRODUCTION TO POWER BI
Congratulations!
INTRODUCTION TO POWER BI

You might also like