Looker Studio Filters Not Working: Why the Wrong Data Appears
When Looker Studio filters do not work, the report shows the wrong data or no data at all. The cause is usually filter logic, the filter scope, the dimension used or a conflict with the underlying source data. Before assuming the filter is broken, separate a filter problem from a source data problem, because they need different fixes.
Table of Contents
- 01.Filter scope and logic
- 02.What to check first
- 03.Include vs exclude logic
- 04.AND and OR logic
- 05.The dimension being filtered
- 06.Filter problems vs source data problems
- 07.Blended data and filters
- 08.How to test the fix
- 09.How to validate the final result
Filter scope and logic
Looker Studio has report filters, page filters and chart-level filters. Each applies at a different scope. A report filter affects every page, a page filter affects one page and a chart filter affects one chart. When filters seem not to work, the scope is often the cause. A filter applied at the chart level does nothing for the rest of the report, and a report filter can override a chart filter in unexpected ways.
| Cause | What happens | How to check |
|---|---|---|
| Wrong scope | Filter applies to wrong charts | Confirm report vs chart filter scope |
| Include vs exclude | Logic reversed | Check whether the filter includes or excludes |
| AND vs OR logic | Wrong combination | Review the filter condition logic |
| Wrong dimension | Filter on unrelated field | Confirm the filtered dimension |
| Source data problem | Field values differ from expectation | Check the source data directly |
What to check first
- Confirm the filter is applied at the correct scope, report, page or chart.
- Check whether the filter is an include or exclude rule and confirm the intent.
- Review the AND and OR logic between conditions.
- Confirm the filtered dimension is the one you expect.
- Open the source data directly and confirm the field values match your filter values.
Include vs exclude logic
A reversed filter is a common mistake. An include filter keeps only matching rows, while an exclude filter removes matching rows. If the report shows the opposite of what you expect, the include or exclude setting is reversed. Confirm the intent and the setting before changing the values.
AND and OR logic
Multiple conditions combine with AND or OR logic. An AND between two conditions requires both to be true, which narrows the data. An OR requires either to be true, which widens the data. A filter that returns too much data often has OR where AND was intended, and a filter that returns too little often has AND where OR was intended. Review the logic between every condition.
The dimension being filtered
A filter only works on the dimension it references. If you filter on a campaign name but the chart groups by a different dimension, the filter narrows the underlying rows but the chart may still show unexpected groupings. Confirm the filtered dimension is the one the chart actually uses. Filtering a dimension that is not in the chart can produce confusing results.
Filter problems vs source data problems
Before blaming the filter, confirm the source data contains the values you expect. A filter that looks broken can be correct while the source data simply does not contain the expected values. Open the source platform or the underlying sheet and check the field values directly. If the values differ from what the filter expects, the filter is correct and the data is the problem.
Blended data and filters
Filters on blended data can behave unexpectedly because the filter applies to the blended result, not always to a single source. A filter on a dimension that only exists in one joined source can exclude rows from the blend. Test filters on each source separately before applying them to the blend.
How to test the fix
- 1.Apply the filter at the correct scope and confirm only the intended charts change.
- 2.Confirm include or exclude logic matches your intent.
- 3.Review AND and OR logic between conditions.
- 4.Confirm the source data contains the values the filter expects.
How to validate the final result
The filter works when the report shows exactly the rows that match the intended logic, removing filters returns the full data set and the same filter applied at the correct scope produces consistent results across charts. If the filter is correct but the data looks wrong, the source data is the problem, not the filter.
Frequently Asked Questions
Why does my Looker Studio filter show no data?
The filter is excluding every row, usually because of an include filter on a value that does not exist in the data or an AND condition that is too restrictive. Remove the filter and add conditions back one at a time to find which one removes all rows.
Why does my filter only affect some charts?
The filter is applied at chart or page scope rather than report scope, or the charts use different dimensions. Confirm the filter scope and the dimension each chart uses, because a filter only affects charts that share the filtered dimension.
Need help applying this to your business?
PPC, Conversion Tracking, CRM and Automation Specialist. Helping businesses generate qualified leads with Google Ads, accurate tracking and automated follow-up.
Related Guides
Looker Studio Showing No Data: How to Diagnose the Problem
No data means either the source has no matching rows or the chart filters everything out. These need opposite fixes, so confirm which one applies before changing the report configuration.
Looker Studio Date Range Not Working Correctly: How to Troubleshoot It
When the date range control does not work, charts ignore the range or stay stuck on a default. The cause is usually the control link, the chart date dimension, the default range or the date field type.
Looker Studio Charts Showing Incorrect Totals: How to Audit the Data
A wrong total can come from the source data, aggregation, blending, a calculation or a filter. Trace the value through each layer to find which one introduced the wrong number before changing the chart.