Jennifer




 
Jennifer :: General :: General Talk :: Different type of filters available in power bi - View Topic
Topic Rating: *****
Printable View
shivani salavi
New Member
*

Posts: 1
Status: Offline
Joined:  

Reputation: 0%  


pm
Different type of filters available in power bi (20th Feb 24 at 12:56pm UTC)
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.
Custom Filters:

Custom Filters: Users can create custom filters using DAX (Data Analysis Expressions) in Power BI. These filters can be more complex and tailored to specific business requirements.
Advanced Filters:

Advanced Filters: Power BI also provides advanced filter options, such as relative date filtering, relative time filtering, and the ability to define filter conditions based on complex expressions.
These filter options in Power BI provide flexibility for users to analyze and visualize data in ways that are relevant to their specific needs and business scenarios.

Read More... Power BI Course in Pune Power BI Course in Pune
Power BI Training in Pune

 Printable View

All times are GMT+0 :: The current time is 10:55pm
Page generated in 4.7938 seconds
Purchase Ad-Free Credits
This Forum is Powered By vForums (v2.4)
Create a Forum for Free | Find Forums