Power BI Filters on Measures

This article shows how to create Power BI Filters on Measures with an example. The Measures Filters are useful for filtering the measures (metric values). For instance, we can use Power BI Filters on Measures to display the products with sales greater than the threshold, less than average, etc.

How to use Power BI Filters on Measures

To demonstrate the Measure Filters in Power BI, we use the Bar Chart we created in our earlier post. As shown in the Power BI screenshot below, we used the State Province Name as an Axis field. We used the Sales amount as a Value field and Order Quantity as Color saturation.

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 is the list of options available for Measures filters in Power BI.

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

Show Items Options

The following is 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 will display.
  2. is less than or equal to: If it is less than or equal to the given value, the record is displayed.
  3. 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 will display.
  6. not: If the record is not equal to the value, then the record is displayed.
  7. is blank: This option displays all the records with empty values.
  8. is not blank: It displays all the records with no blank values.

For these Measure Filters in Power BI demonstration purposes, we selected is greater than as the operator and 1000000 as the value. Next, click the Apply Filter option (hyperlink) to apply the changes.

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

change the Condition to greater than 6

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

Power BI Filters on Measures 7

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

Is Blank Option 8

Let me use multiple Power BI filters on the Sales Amount Measure 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 the AND operator to join those two filters.

Power BI Filters on Measures 9

The screenshot below shows that the report displays the states whose sales amount is greater than 300000 and less than 2300000.

Using Multiple conditions 10

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

Final Report 11

The remaining filters are shown below.

  1. Slicer
  2. Basic Filters
  3. Top N Filters
  4. Page-Level Filters
  5. Report Level Filters
  6. Drill through Filters

Comments are closed.