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
    • Python Programs
    • Java Programs
    • SQL FAQ’s

Power BI Filters on Measures

by suresh

How to create Power BI Filters on Measures with an example?. Power BI Measures Filters are used to filter the measures (metric values). For example, we can use Power BI Filters on Measures to display the products with sales greater than the threshold, or less than average, etc.

How to use Power BI Filters on Measures

To demonstrate the Measure Filters in Power BI, we are going to use the Bar Chart that we created in our earlier post. As you can see from the Power BI screenshot below, we used the State Province Name as an Axis field. And we used the Sales amount as a Value field, and Order Quantity as Color saturation.

Power BI Filters on Measures 1

Under the Filters section, you can see the list of available Power BI Filters on Measures

Power BI Filters on Measures 2

Let me expand the Sales Amount to see the filter options. The following are the list of options that are available for Measures filters in Power BI

  • Show Items when the Value: Please select the operator that you want to use.
  • Empty Text box: Please specify the value.
  • And and Or: Same as AND and OR Operators SQL. Use this to concatenate multiple filters.
  • Empty drop down list: Please select the second operator that you want to use.
  • Empty Text box: Please specify the value for the second filter.
Power BI Filters on Measures 3

The following are the list of Power BI Filters on Measures options available under the Show items when the value section:

  1. is less than: When this option is selected, it checks each record against the Value. And if it is less than the user-specified value, then the record displayed.
  2. is less than or equal to: If it is less than or equal to the given value, then the record displayed.
  3. is greater than: Displays the records whose sales amount is greater than the specified value
  4. is greater than or equal to: Displays the records whose sales amount is greater than or equal to a given value.
  5. is: If the record matches exactly with the value, then the record display.
  6. is not: If the record is not equal to the value, then the record display.
  7. is blank: It displays all the records with the blank values.
  8. is not blank: It displays all the records that contain no blank values.
Power BI Filters on Measures 4

For these Measure Filters in Power BI demonstration purpose, we selected is greater than as the operator, and 1000000 as the value.

Power BI Filters on Measures 5

The report below is displaying the states whose Sales Amount is greater than 1000000.

Power BI Filters on Measures 6

Let me change the operator to is less than and value as 1000. From the below image, you can see that the report is displaying the states whose sales amount is less than 1000

Power BI Filters on Measures 7

This time we are using the is blank operator. You can see that the report is blank because we don’t have any state that contains blank sales.

Power BI Filters on Measures 8

Let me use multiple filters on the Sales Amount column. The First filter finds the states with sales greater than 300000, and the second filter finds the states whose sales are less than 2300000.

We used AND operator to join those two filters

Power BI Filters on Measures 9

From the screenshot below, you can see that the report is displaying the states whose sales amount is greater than 300000 and less than 2300000.

Power BI Filters on Measures 10

The report below is displaying the states whose sales amount is greater than 300000, or the sales amount is less than 1000.

Power BI Filters on Measures 11

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
  • C Tutorial
  • C# Tutorial
  • Java Tutorial
  • JavaScript Tutorial
  • Python Tutorial
  • MySQL Tutorial
  • SQL Server Tutorial
  • R Tutorial
  • Power BI Tutorial
  • Tableau Tutorial
  • SSIS Tutorial
  • SSRS Tutorial
  • Informatica Tutorial
  • Talend Tutorial
  • C Programs
  • C++ Programs
  • Java Programs
  • Python Programs
  • MDX Tutorial
  • SSAS Tutorial
  • QlikView Tutorial

Copyright © 2021 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy