

0 / 2 embers
0 / 3000 xp
click for more info
Complete a lesson to start your streak
click for more info
Difficulty: 2
click for more info
Not enough gems
Cost: 6 gems
1: Power Query
incomplete
2: Python Scripts in Power Query
incomplete
3: Removing Duplicates
incomplete
4: Split a Column
incomplete
5: Merging Columns
incomplete
6: Missing Values
incomplete
7: Performance Considerations
incomplete
8: Data Refresh
incomplete
9: Data Refresh
incomplete
10: Formatting
incomplete
11: Filters
incomplete
Back
ctrl+,
Next
ctrl+.
This lesson's interactive features are locked, please to keep using them
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.
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.
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.