Ravindra BagaleCourses & study guides

22. Filters and Slicers

22.1 The Filters Pane and Its Levels

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

  1. Click an empty area of the page so no visual is selected.
  2. Drag Orders[Platform] from the Data pane into Filters on this page.
  3. The filter card opens in Basic filtering. Tick Blinkit.
  4. Every visual on the page now shows Blinkit only. The card shows "Platform is Blinkit".

Ravindra Bagale's Tip

Mitrano, khup 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. Dhyan rakho!