Scribd
Upload
5 views14 pages

Power BI: Drilling Down & Filtering Guide

The document introduces the concepts of drilling down and filtering in Power BI, explaining how to display data at different levels of detail. It covers hierarchies, the ability to drill down on visuals, and various types of filters, including visual-level, page-level, and report-level filters. Additionally, it discusses the option to turn off filtering to prevent end-users from altering report filters.

Uploaded by

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

Power BI: Drilling Down & Filtering Guide

The document introduces the concepts of drilling down and filtering in Power BI, explaining how to display data at different levels of detail. It covers hierarchies, the ability to drill down on visuals, and various types of filters, including visual-level, page-level, and report-level filters. Additionally, it discusses the option to turn off filtering to prevent end-users from altering report filters.

Uploaded by

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

Dri ling down

and filtering
INTRODUC TION TO POW
ER BI

Rohan Sharma
Data Analysis Trainer
Drilling down

Show data at a high level

Option to show a more detailed


level

INTRODUCTION TO POWER
Hierarchies
Example Example
1 2

INTRODUCTION TO POWER
Drilling down on a
visual

INTRODUCTION TO POWER
Drill down all fields at
once

INTRODUCTION TO POWER
Drill down all fields at
once

INTRODUCTION TO POWER
Drill down all fields at
once

INTRODUCTION TO POWER
Expand all fields at
once

INTRODUCTION TO POWER
Expand all fields at
once

INTRODUCTION TO POWER
Expand all fields at
once

INTRODUCTION TO POWER
Expand all fields at
once

INTRODUCTION TO POWER
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
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
Let's
practice!
INTRODUC TION
TO POW E R B
I

You might also like