Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs

Power BI Basic Filters

by suresh

Power BI Filters are useful to restrict the data as per the requirements. For example, using Power BI basic filters, we can exclude a product from the display, or we can display top/bottom 10 performing records. Let me show you how to create Power BI basic filters with example.

How to use Power BI Basic Filters

To demonstrate the Basic Filters in Power BI, we are going to use the Clustered Column Chart that we created in our earlier post. As you can see from the screenshot Power BI below, we used the Country Name as the Axis field, Occupation as Legend field, and Sales amount as the Value field.

Power BI Basic Filters 1

Under the Filters section, you can see the list of filters that are available in Power BI

  • Visual Level Filters: It includes Filters on Dimension, Filters on Measures, Basic Filters, Advanced Filters, and Top N filters
  • Page-Level Filters: These Page Level Filters apply to all the visuals present in the current page.
  • Drill through Filters: This Drill through Filters helps you to drill through the particular region, or particular category, etc.
  • Report Level Filters: These Report Level Filters apply to all the pages that are present in the current Report.
Power BI Basic Filters 2

Let me expand the English Country Region Name (in Short Country) to see the filter types.

Power BI Basic Filters 3

Use the drop-down list to see the list of Power BI filter types available for dimension.

  • Advanced Filtering: This option helps you to use more advanced options like starts with, ends with, contains, etc.
  • Power BI Basic Filters: It used to perform basic operations.
  • Top N: Use this to find the top 10 records or bottom 10 records.

In this example, we want to discuss the Power BI basic filters so, let me select the same.

Power BI Basic Filters 4

Selecting Basic Filters in Power BI display the rows that are available for this column. You can use the checkboxes to select One, None (or All)

Let me select Australia, Germany, the United Kingdom, and the United States. From the screenshot below, you can see that the clustered column chart is displaying the column that belongs to sleeted countries.

Power BI Basic Filters 5

Required Single Selection: It restricts us to select one field at a time. I mean, now you can select only one country name at a time.

Power BI Basic Filters 6

As you can see, we selected the United States.

Power BI Basic Filters 7

By unchecking the Required Single Selection property, you can select multiple fields.

Power BI Basic Filters 8

By clicking that little tiny clear filter button helps you remove the existing filters.

Power BI Basic Filters 9

Power BI basic Filters on Multiple dimensions

Let me expand the English Occupation column to apply filters on Occupation.

Power BI Basic Filters 10

Let me select the Management, Professional, and Skilled Manual fields as the basic filtering values. As you can see from the screenshot below, it is displaying 4 countries that we selected in Countries Filters and Three occupations that we selected now.

Power BI Basic Filters 11

This time, we are selecting a single field, i.e., Skilled Manual.

Power BI Basic Filters 12

Delete Power BI Filters

Click on the tiny little Clear filter button to delete existing filters. For the demo purpose, let me delete the filter on the Occupation field.

Power BI Basic Filters 13

You can see that the Occupation field has no Filters

Power BI Basic Filters 14

Let me remove the filters on the Country

Power BI Basic Filters 15

Now you can see there are no filters in this Clustered Column Chart.

Power BI Basic Filters 16

Placed Under: Power BI

  • Install Power BI Desktop
  • Connect Power BI to SQL Server
  • Add Rename and Duplicate Pages
  • Connect to Multiple Excel Sheets
  • Get Excel Data to Power BI
  • Get Text File Data to Power BI
  • Load Data from Multiple Sources
  • Remove Power BI Table Columns
  • Create Power BI Bins
  • Power BI Joins
  • Change Column Data Types
  • Combine Multiple Tables
  • Power BI Clusters
  • How to Enter Data into Power BI
  • How to Format Dates in Power BI
  • Create Power BI Groups
  • Create Power BI Query Groups
  • Create Power BI Hierarchy
  • Power BI Pivot Table
  • Power BI Unpivot Table
  • Rename Power BI Table Names
  • Rename power bi column names
  • Split Columns in Power BI
  • Remove reorder power bi column
  • Power BI Area Chart
  • Format Power BI Area Chart
  • Power BI Bar Chart
  • Format Power BI Bar Chart
  • Power BI Clustered Bar Chart
  • Clustered Column Chart
  • Create a Power BI Card
  • Format Power BI Card
  • Create Power BI Multi-Row Card
  • Format Power BI Multi-Row Card
  • Power BI Column Chart
  • Format Power BI Column Chart
  • Power BI Donut Chart
  • Format Power BI Donut Chart
  • Power BI Funnel Chart
  • Format Power BI Funnel Chart
  • Power BI Heat Map
  • Power BI Line Chart
  • Format Power BI Line Chart
  • Line & Clustered Column Chart
  • Format Line & Clustered Column
  • Line & Stacked Column Chart
  • Format Line & Stacked Column
  • Power BI Matrix
  • Format Power BI Matrix
  • Power BI Table
  • Format Power BI Table
  • Add Data Bars to Power BI Table
  • Add alternate Table Row Colors
  • Power BI Pie Chart
  • Format Power BI Pie Chart
  • Power BI Ribbon Chart
  • Format Power BI Ribbon Chart
  • Power BI Treemap
  • Format Power BI TreeMap
  • Power BI Scatter Chart
  • Format Power BI Scatter Chart
  • Power BI Stacked Area Chart
  • Power BI Stacked Bar Chart
  • Format Stacked Bar Chart
  • Power BI Stacked Column Chart
  • Format Stacked Column Chart
  • Power BI Waterfall Chart
  • Format Power BI Waterfall Chart
  • Power BI 100% Stacked Bar Chart
  • 100% Stacked Column Chart
  • Create a Power BI Map
  • Format Power BI Map
  • Power BI Filled Map
  • Format Power BI Filled Map
  • Power BI Basic Filters
  • Power BI Slicer
  • Power BI Top 10 Filters
  • Power BI Drill through Filters
  • Power BI Filters on Measures
  • Power BI Advanced Filters
  • Power BI Report Level Filters
  • Power BI Page Level Filters
  • Power BI Calculated Columns
  • Add Conditional Column
  • Create Power BI Custom Column
  • Power BI Calculated Measures
  • Power BI Calculated Tables
  • Power BI DAX String Functions
  • Power BI DAX Math Functions
  • DAX Trigonometric Functions
  • Power BI DAX Date Functions
  • Power BI DAX Logical Functions
  • Power BI DAX Agg. Functions
  • Power BI Dashboard Introduction
  • Power BI Dashboard Settings
  • Power BI Dashboard Actions
  • Delete Power BI Dashboard
  • Subscribe Power BI Dashboard
  • Add Web Content to Dashboard
  • Add Image to Dashboard
  • Add video to power bi dashboard
  • Add Title to Power BI Dashboard
  • Pin Workbooks to Dashboard
  • Register to Power BI Service
  • Connect to Power BI Service
  • Create Power BI Workspace
  • Share Power BI Workspace
  • Create a Report in Workspace
  • Rename a Report in Workspace
  • Rename a Dataset in Workspace
  • Quick insights in Power BI
  • Get insights in Power BI
  • Publish power bi desktop report
  • Upload Power BI Workbooks
  • Upload Excel Files to Dashboard
  • Edit Power BI App
  • View Published Power BI App
  • Publish Power BI App
  • Share Power BI Dashboard
  • Share Power BI Workspace
  • Share Power BI Report
  • Power BI Q&A
  • Power BI Q&A Advanced
  • Customize Q&A Suggestions

Copyright © 2021· All Rights Reserved.
About | Contact | Privacy Policy