What is the Different type of filters available in power bi ?
Power BI provides various types of filters that allow users to control and manipulate the data displayed in reports and dashboards. Here are some of the main types of filters available in Power BI:
- Visual-Level Filters:
- Filter on Visual: Each visual (chart, table, etc.) in Power BI can have its own visual-level filters. These filters are specific to the visual and only affect the data displayed within that particular visual.
- Page-Level Filters:
- Filter on Page: Filters can be set at the page level, affecting all visuals on a specific page. This is useful when you want to maintain consistency in the data displayed across multiple visuals.
- Report-Level Filters:
- Filter on All Pages: Report-level filters apply across all pages in a report. They help in maintaining consistent filtering criteria throughout the entire report.
- Drillthrough Filters:
- Drillthrough Filters: This type of filter allows users to create a hierarchy of related pages. When users drill through a data point in a visual, they are taken to a new page with more detailed information based on predefined drillthrough filters.
- Relative Date Filters:
- Relative Date Filters: These filters enable users to filter data based on relative time periods, such as the last 7 days, next month, etc. This provides dynamic filtering based on the current date.
- Top N Filters:
- Top N Filters: Users can filter data to display the top or bottom N items based on a selected measure. For example, display the top 10 products by sales.
- Relative Filters:
- Relative Filters: Similar to relative date filters, relative filters allow users to filter data based on relative values. For instance, show data where sales are greater than the average sales for the selected category.
- Cross-Filtering and Highlighting:
- Cross-Filtering and Highlighting: Users can interactively filter data by selecting data points in one visual and seeing the corresponding changes in other visuals. Cross-filtering changes the data in related visuals, while highlighting emphasizes the selected data points.
Read More details… Power BI Training in Pune
