22.1 The Filters Pane and Its Levels
Start with a problem
Rani sees ₹250 on a card and nobody can explain it. The report has filters at several levels.
Explain simply
The Filters pane has three levels: visual (one visual), page (all visuals on one page) and report (all pages). All levels combine with AND.
Show the data
| Order ID | Order Date | City | Store | Platform | Category | Amount (₹) | Delivery mins | Status |
|---|---|---|---|---|---|---|---|---|
| 301 | 06-Apr-2026 | Pune | Kothrud | Blinkit | Dairy | 400 | 8 | Delivered |
| 302 | 06-Apr-2026 | Pune | Baner | Amazon Now | Snacks | 200 | 12 | Delivered |
| 303 | 07-Apr-2026 | Nashik | Gangapur | Blinkit | Dairy | 300 | 14 | Delivered |
| 304 | 04-May-2026 | Nashik | College Road | Blinkit | Fruits | 150 | 9 | Delivered |
| 305 | 04-May-2026 | Kolhapur | Rajarampuri | Amazon Now | Snacks | 450 | 7 | Delivered |
| 306 | 05-May-2026 | Pune | Kothrud | Blinkit | Fruits | 250 | 16 | Delivered |
| 307 | 05-May-2026 | Nashik | College Road | Amazon Now | Dairy | 350 | 11 | Delivered |
| 308 | 05-May-2026 | Kolhapur | Rajarampuri | Blinkit | Dairy | 0 | Cancelled |
About this data: This table uses columns: Order ID, Order Date, City, Store, Platform, Category, Amount (₹), Delivery mins, Status. This table uses columns: Filters applied, Rows left, Total Sales. This table uses columns: Level, Applies to, How to add. This table uses columns: Wrong result, Reason, Correction. Values shown are the lesson examples already on this page (not a new dataset).
Fictional sample data. Practice file: visuals_orders_apr_may_2026.csv (source: src/practice/).
Demonstrate
- Open the Filters pane.
- Filters on all pages: Platform = Blinkit.
- Filters on this page: Month = May-2026.
- Select the card › Filters on this visual: City = Pune.
- Read the card, then remove the filters one at a time.
Show the result
Your result should look like this (fictional sample):
| Filters applied | Rows left | Total Sales |
|---|---|---|
| Report: Blinkit | 301, 303, 304, 306, 308 | ₹1,100 |
| + Page: May | 304, 306, 308 | ₹400 |
| + Visual: Pune | 306 | ₹250 |
Explain what happened
Each level narrows the rows the measure can see; the card evaluates Total Sales on the rows that pass all three.
Explore further
- Locked and hidden filters (22.6) still apply.
Detailed reference for this lesson:
Open it on the right side of Report view (or View › Filters).
| Level | Applies to | How to add |
|---|---|---|
| Filters on this visual | Only the selected visual | Select the visual. Its fields appear automatically, and you can drag more fields into this section |
| Filters on this page | All visuals on the current page | Drag a field into this section |
| Filters on all pages | Every page of the report | Drag a field into this section |
| Drill through | The drill-through target page | Set on the target page (Module 17) |
Steps in Power BI – a page filter for Maharashtra dark stores of Blinkit
- Click an empty area of the page so no visual is selected.
- Drag
Orders[Platform]from the Data pane into Filters on this page. - The filter card opens in Basic filtering. Tick Blinkit.
- Every visual on the page now shows Blinkit only. The card shows "Platform is Blinkit".
Ravindra Bagale's Tip
Friends, many students put a filter at visual level on one chart and then wonder why other visuals disagree. Decide the scope first: visual, page or all pages. Check the Filters pane of every visual when numbers don't match. Keep this in mind!
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students एका chart वर visual level ला filter लावतात आणि मग इतर visuals वेगळे numbers का दाखवतात याचा विचार करतात. आधी scope ठरवा: visual, page की सगळी pages. Numbers जुळत नसतील तर प्रत्येक visual चा Filters pane चेक करा. लक्षात ठेवा!
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students एक chart पर visual level पर filter लगाते हैं और फिर सोचते हैं कि दूसरे visuals अलग numbers क्यों दिखा रहे हैं. पहले scope तय करो: visual, page या सभी pages. Numbers मेल न खाएँ तो हर visual का Filters pane check करो. ध्यान रखना!
Fix common mistakes
| Wrong result | Reason | Correction |
|---|---|---|
| Card value unexplained | Hidden report filter | Check all three levels |
| Filter on one page affects another | Report-level filter | Move it to page level |
| Visual ignores page filter? | It never does – visual filters add, not replace | Look for CALCULATE in the measure |
Practise independently
Practice task
Remove only the visual filter. What is the card?
Hints
- Blinkit + May.
Solution
₹400 (304, 306, 308).
Think like a professional
Unexplained numbers usually come from forgotten filters. Check the Filters pane before debugging DAX.
Revision card