We're sorry but this app doesn't work properly without JavaScript enabled. Please enable it to continue.

This lesson's interactive features are locked, please to keep using them

Filters

Formatting improves how your charts look, while filters control what data they display. They're perfect for slicing the data at view time into specific regions, time periods, or categories without changing your dataset or power query transformations.

There are three main types of filters in Power BI, and they're shown in the "Filters" pane to the left of the "Visualizations" pane.

  1. Visual-Level Filters: Affect only the selected chart
  2. Page-Level Filters: Affect all visuals on the same page
  3. Report-Level Filters: Affect every page in the entire report

I use filters depending on who is using this dashboard/visualization. Do they need all the data? Will they want to filter on something specific? Then I'll add whichever filter I need.

Assignment

  1. Be careful not to add a page-level filter! If one lands under "Filters on this page" by mistake, hover it and click the X to remove it.

Save the project and, from the course directory, submit the CLI tests.