“Why does this card show a different total from that chart?” is one of the most common Power BI questions, and the answer is almost always filters. Power BI applies filters at several levels at once, and understanding them makes your reports trustworthy.
The four places filters come from
- Visual-level filters: apply to one visual only, set in the Filters pane under “Filters on this visual”.
- Page-level filters: apply to every visual on one page.
- Report-level filters: apply to every page in the report.
- Slicers: visible on the page, so report users can change them.
On top of these, clicking a bar in one chart cross-filters or cross-highlights the other visuals on the page.
Slicers vs Filters pane
Use slicers for the few choices users change often, such as year, region or product category. Use the Filters pane for fixed rules, such as excluding test data or cancelled orders, and lock or hide those filters so users cannot change them by accident.
Controlling interactions
Select a visual, then Format, then Edit interactions. For each other visual you can choose filter, highlight or none. A KPI card showing the company total, for example, should usually ignore clicks on a regional chart.
Syncing slicers across pages
View, then Sync slicers, lets one slicer control several pages, so a user who picks “2026” does not have to pick it again on every page.
Filters and DAX measures
Every filter changes the context in which measures are calculated. If a measure must ignore a slicer, for example to show a share of the total, use CALCULATE with ALL or REMOVEFILTERS on that column.
Avoiding confusing reports
- Show the active filters, for example with a text box or card that displays the selected year.
- Keep hidden filters to a minimum, and document them.
- Test the report by clearing all slicers and checking that totals match the source data.
Related: Power BI relationships and filter direction, DAX CALCULATE and dashboard design mistakes.
Power BI is taught with real reports in our 5-month Data Analytics course in Bangalore.
Book a free demo class at our BTM Layout centre, and ask a counsellor for batch details.
