1. Home
  2. Training Library
  3. Big Data
  4. Courses
  5. Introduction to Power BI

Filters

Contents

keyboard_tab
Course Introduction
Primary Power BI Components
2
Visualizations
PREVIEW5m 33s
3
Filters
PREVIEW1m 22s
Filters
Overview
Difficulty
Beginner
Duration
35m
Students
115
Ratings
5/5
starstarstarstarstar
Description

Power BI has changed the BI landscape forever, enabling BI professionals and regular Excel users alike to work with big data and build insightful dashboards. 

Learn to use this powerful business intelligence solution from the ground up. Navigate the intuitive user interface and explore the ecosystem of data modeling tools. Discover outside-the-box visualizations and broadcast your insights to colleagues in the Power BI Service. This course gives you a solid foundation to begin your Power BI journey. 

Learning Objectives

On completing this course, learners will be able to:

  • Identify the primary components of the Power BI interface: reports, data, and model views
  • Import Excel data and build basic visuals
  • Publish a desktop report to the Power BI Service
  • Identify common challenges in Power BI data models, implement smart solutions, and avoid common mistakes

Intended Audience

  • Business professionals whose job requires them to design, build, or deliver business intelligence metrics
  • Anyone preparing to take the Microsoft PL-900 exam

Prerequisites

A desire to learn to use Power BI

Transcript

Power BI has a bunch of convenient ways to filter data. And like the rest of the Power Platform, these tools can be used by you to perform your own analysis, or you can provide access to other people in your organization. We will refer to these people as consumers. The Filters pane is pretty slick. It gives you three scopes. If we want to filter just this visual, we can add the field to filter by, and then make our selection, and now our whole visual is filtered. We can also add Filters that affect all visuals on this page. Finally, we can add a filter that affects all the pages in this report. That means that after I've applied the filter and I select on these other pages, they will be filtered as well.

When you start using this filters pane, you may find that sometimes it can get a bit cluttered looking, so this nifty search box at the top helps you find exactly what you're looking for. There is also a feature that allows you to click on a chart element to drill down into segments of data in order to see more detail about that segment. You can continue to explore successive layers of detail as far down as your data goes. Now this Drill Down feature does require a bit of setup. Just click this button on the visual. This activates Drill Down mode. Now your consumers will be able to drill down by clicking on a topic of interest.

About the Author
Avatar
Chelsea Dohemann
Senior Technical Trainer and Microsoft Certified Master
Students
580
Courses
2

Chelsea Dohemann is a Senior Technical Trainer and Microsoft Certified Master with almost a decade of experience in technology training. She has taught an array of applications from Microsoft products including Office 365 web apps, Microsoft Office Suite, Power BI, VBA for Excel, and SharePoint to Adobe Acrobat Pro and Creative Cloud. Being a persistent learner herself, Chelsea is acutely in-tune with the challenges of learning. She presents her topics in plain language, with real-world examples, reducing complex concepts down to their simple parts.