Power BI – Page Level Filters
When you run a Power BI report on the Power BI Service, the Pollutants pane is located rather inconspicuously on the right side of your screen. The Pollutants pane is collapsed by dereliction, but you can expand it by clicking it formerly. Once it’s expanded, you can resize it by clicking and dragging the left edge.
Filters in Power BI sort data and information grounded on some named criteria. That is, you can elect particular fields or values within fields and view only the information related to them. Power BI displays your data by refining data relevant to you. With a filter in Power BI, you can:
- Work with smaller parts of your data.
- Do calculations for particular groups of interest.
- Exclude “bad” data from data visualizations.
- Train and validate statistical models.
Page Filters applies filters to all its included illustrations. To use page level filter, you can use the option “filter on this page” from the filter pane. Page-level filters are incredibly helpful while preparing company-wide reports, wherein you can produce separate filters for separate pages of your Deals, Marketing, and Support.
Page-level filters only filter the info on a given page, making them useful for creating pages specializing in particular subsets of your data. for instance, you’ll use page-level filters to make one-page focus solely on revenue data, while the subsequent page focuses on expense data. Page-level filters operate within the context of the report-level filters, which suggests that a page-level filter cannot override a report-level filter. They also can’t be programmed to filter the data on other pages.
Application of Page-level Filters
Import data from Your Excel to Power BI:
Home Tab -> Get Data -> Choose Data which you want Example Excel -> Select the file and Open -> Select The sheet and Load
In the Filter Section, there are only two options:
- Filter on this page – it represents the Page level Filter
- Filter on all pages – it represents the Report level filter
Creating a stack bar chart to demonstrate page-level filters:
To create a ‘Chart’ drag and drop the data under respective fields.
To demonstrate Page level filter we create a table on the same page for a better explanation
At this stage Power BI dashboard is shown below:
To use a page-level filter drag and drop the field under the page filter
To look for a particular product sold:
Filter on this Page -> Product Name-> Filter type -> Base Filtering -> Select the product
To apply conditional Filtering ‘Advance Filtering’ used
Play with data by loading the other fields on the page-level filters and try to understand the concept. Page-level filters are used for a specific page within a report. You’ll apply certain filter conditions on a selected page within a report using these filters. Moreover, each page during a report can have a different filter applied to it.