What is the difference between a slicer and a filter?

Question

Accepted Answer

Slicers and filters are both used to control data visibility in Power BI, but slicers are visual elements while filters can be applied programmatically.

Slicers are visual controls that allow users to select values from a predefined list, which filters the data accordingly.
Filters can be applied programmatically using DAX formulas or Power Query M language.
Slicers are typically used for interactive data exploration and analysis, while filters are more commonly used for data manipulation and calculations.
Slicers can be added to a report page to provide a user-friendly way to filter data, while filters can be applied at the report, page, or visual level.
Example: A slicer for selecting a specific product category, and a filter to show only sales data for the current year.

Accepted Answer

In Power BI, a slicer is a visual control allowing users to select specific values from a field, applying filters across the entire report. Filters, on the other hand, are criteria applied to visuals, pages, or reports to display only data meeting specified conditions, influencing data visibility dynamically.

Accepted Answer

SLicer is an on canvas visual while filter is backend. Slicer is dynamic filter while filters are actually static for the report

Asked in KPMG India

What is the difference between a slicer and a filter?

Interview Questions Asked to Power BI Developer at Other Companies

Top Skill-Based Questions for KPMG India Power BI Developer