06 Filters Flashcards
What are Visual Level Filters in Power BI?
Affect only a single visual on a page.
Use case includes isolating specific data within a chart without changing other visuals.
What is an example of a Visual Level Filter?
Filtering out ‘Snacks’ from a product category chart.
This isolates the data displayed in that specific visual.
What are Page Level Filters in Power BI?
Apply to all visuals on a specific page.
Ensures consistency across visuals on a single page.
What is an example of a Page Level Filter?
Filtering for a specific date range to update all charts on a sales performance page.
This maintains a uniform view across the page.
What are Report Level Filters in Power BI?
Affect all pages and visuals within an entire report.
Ensures a consistent filter across a multi-page report.
What is an example of a Report Level Filter?
Filtering for a specific year to analyze data across different departments or categories.
This allows for comprehensive analysis across the report.
What is Basic Filtering in Power BI?
Simple selection or exclusion of data points.
Example includes choosing specific countries from a list.
What is Top N Filtering?
Displays the top N items based on a measure.
Example includes showing the top 5 selling products.
What is Advanced Filtering?
More complex filtering based on conditions or text.
Example includes filtering for products with names containing ‘Chocolate.’
What is one benefit of using filters in Power BI?
Focus on specific data.
This allows users to isolate relevant information for analysis.
How do filters improve decision-making?
Make informed decisions based on filtered data.
Filters provide clarity and focus on pertinent information.
What should filter labels be like for effective filtering?
Clear and descriptive.
This improves understanding of what each filter does.
What is a tip for using Visual Cues in filtering?
Use colors or icons to indicate active filters.
This helps users quickly identify what filters are applied.
What is the advantage of combining filter types?
Allows for complex analysis.
Using multiple filters can yield deeper insights.
True or False: Understanding different filter types is crucial for effective data visualization.
True.
Different filter types serve various analytical purposes.
Fill in the blank: Filters in Power BI help with _______.
Customized Insights.
This allows users to tailor visualizations to specific needs.
