Filters in Power Bi Reports

What are Power BI Filters?

Power BI Filters are used to restrict the data and show only specific kind of data. The filters are very useful when you have huge amount of data and you want to see only small amount of data. For example you have huge amount of sales data for different countries, but you want to see data for 2019 and country as "USA" then in this case you can apply year and country filter to exclude unnecessary data and show only 2019 sales of USA. To Add any filter in Power BI, simply drag and drop any field in add data field section of each filter type.

 



Types of Power BI Filters?
 1. Visual Level Filters
 2. Report Level Filters
 3. Page Level Filters 

Visual Level Filters 
The filters applied to visual-level are applied directly on individual visualizations. The filter is specific to single visualization. This filter does not affect on other visuals or pages.

Report Level Filters
The filters applied to Report-level are applied directly to all the visualization and pages within the report. 

Page Level Filter 
The filters applied to Page-level are applied to all the visualization in single page. Page level filters will not get applied to other pages. It affects only single page.

You can see these 3 types of filters , In Filter selection pane.

For more information about Power BI Training Course Click Here

Comments

Post a Comment

Popular posts from this blog

What is Ansible and How to Use Ansible in Docker

Image
 What is Ansible and How to Use Ansible in Docker Ansible is an open-source software provisioning, configuration management, and application-deployment tool enabling infrastructure as code. It runs on many Unix-like systems, and can configure both Unix-like systems as well as Microsoft Windows. Benefits of Ansible:   Free:  Ansible is an open-source tool. Very simple to set up and use: No special coding skills are necessary to use Ansible’s playbooks (more on playbooks later). Powerful:  Ansible lets you model even highly complex IT workflows. Flexible:  You can orchestrate the entire application environment no matter where it’s deployed. You can also customize it based on your needs. Agentless:  You don’t need to install any other software or firewall ports on the client systems you want to automate. You also don’t have to set up a separate management structure. Efficient:  Because you don’t need to install any extra software, there’s more room f...
Read more