How To Remove Filter From Power BI DAX

In this Power BI Tutorial, we will learn how to remove the filter value from the visual using the Power BI DAX function. We will also be going to cover the below-mentioned headings with various examples.

Recently, I was working on the Power Bi report, where we need to remove the filter value for the selected visual or the page filter. To accomplish it, I have used the Power BI Dax Remove Filter function.

  1. What is Power BI DAX remove filter?
  2. How do use Power BI DAX remove visual filter
  3. How to remove page filter in Power BI DAX
  4. How to work with Power BI DAX remove slicer filter
  5. How to remove all filters using Power BI DAX
  6. How to work with Power BI DAX remove one filter
  7. How can we remove specific filter in Power BI

Power BI DAX remove filter

Let us see how we can use the Remove filter function which clears filters from the mentioned tables or columns using the Power Bi Dax filter function in Power BI.

In this example, I have used the Bikes table data, where the bike table contains four different columns they are, Bike Model, Bike Names, color, and price.

  • Initially, open the power bi desktop and load the data into it, click on the new measure option from the ribbon and apply the below formula into it.
Remove Filter = CALCULATE([Total],REMOVEFILTERS(Bikes[Color] ),Bikes[Color]="Red")

Where,

  1. Remove Filter = Measure Name
  2. Total = Calculated Measure Value
  3. Bikes = Table Name
  4. Color = Column Name
  • Now from the visualization, select the Table visual and then drag and drop the field values and the created remove filter measure value into it.
  • In the below screenshot, you can see that the table visual remove filter column displays the value based on the condition applied it removes other values except for the filtered value.
Power BI DAX remove filter
Power BI DAX remove filter

This is how to use the Remove filter function in Power BI Dax to filter the values in Power BI.

Also Read: How to Filter Blank Value in Power BI

Power BI DAX remove visual filter

Let us see how we can use the remove visual filter using the filter function in Power BI.

In this example, I’ll show you how to remove the filter from the table visual in the Power BI report.

  • Open the power bi desktop and load the data into it, select the report and click on the table visual for which you want to apply the filter.
  • Then Expand the Filters pane and apply the filter based on the column field under the Filters in this visual section. The Visualization will automatically change based on the applied filter.
  • In this example, I am going to filter the data based on the selected visual, you can see that I am going to filter the data based on the Bike Model for the selected visual as shown below:
Power BI DAX remove visual filter
Power BI DAX remove visual filter
  • The below screenshot represents the data based on the filter applied, it displays data for the selected bike model.
Power BI DAX remove visual filter example
Power BI DAX removes visual filter example
  • Now to remove the applied filter, click on the clear filter option as highlighted below, which will remove the filtered data value from the table visual.
Example of Power BI DAX remove visual filter
Example of Power BI DAX removes the visual filter

This is how to filter or remove data value from the visual in the Power BI report.

See also  How to Check IF Text is NULL in Power BI

Check out: Power BI DAX Filter If [With Real Examples]

Power BI DAX remove page filter

Let us see how we can remove the page filter using the filter function in Power Bi.

In this example, I’ll show you how to remove the filter from the Power BI report page.

  • Open the Power BI report page for which you want to apply the filter.
  • Then Expand the Filters pane and apply the filter based on the column field under the Filters on this page section. The Report page will automatically change based on the applied filter.
  • In this example, I am going to filter the data based on the Bike model for the selected Power Bi report page as shown below:
Power BI DAX remove page filter
Power BI DAX remove page filter
  • The below screenshot represents the data based on the filter applied, it displays filtered data for the selected bike model in both the table and the matrix visual Presented on the Power BI report page.
Power BI DAX remove page filter example
Power BI DAX remove page filter example
  • Now to remove the applied filter, click on the clear filter option as highlighted below, this will remove the filtered data value from the Power Bi report page.
Example of Power BI DAX remove page filter
Example of Power BI DAX remove page filter

This is how to filter or remove data value from the Power BI report page in Power Bi.

Read: Power BI Dax Filter [With 15+ Examples]

Power BI DAX remove slicer filter

Let us see how we can remove the slicer filter using the filter function in Power bi.

  • Open the Power Bi desktop and load the data into it. Select the Slicer visual from the visualization, then drag and drop the Bike name field from the field pane.
  • Now select the card visual to display the selected filter value data as shown below:
Power BI DAX remove slicer filter
Power BI DAX remove slicer filter
  • Now to remove the applied filter, click on the clear filter option from the slicer visual as highlighted below: The card visual will not display any values because the applied filter has been removed.
Power BI DAX remove slicer filter example
Power BI DAX remove slicer filter example

This is how to remove the slicer filter using the filter function in Power bi.

See also  Power BI Group by | Power BI Count Group by

Read: Power Query Add Column Date [15 Examples]

Power BI DAX remove all filter

Let us see how we can use the Remove all filter function using the Power Bi Dax filter function in Power BI.

  • Initially, open the power bi desktop and load the data into it, click on the new measure option from the ribbon and apply the formula below.
Remove All Filter = CALCULATE([Total],ALL(Bikes[Bike Names]),REMOVEFILTERS(Bikes[Color] ),Bikes[Color]="White")

Where,

  1. Remove All Filter = Measure Name
  2. Total = Calculated Measure Value
  3. Bikes = Table Name
  4. Color = Column Name
  • Now from the visualization, select the Table visual and then drag and drop the field values and the created remove filter measure value into it.
  • In the below screenshot, you can see that the table visual remove filter column displays the value based on the condition applied it removes other values except for the filtered value.
Power BI DAX remove all filter
Power BI DAX remove all filter

This is how to use the Remove all filter function which clears filters from the mentioned tables or columns using the Power Bi Dax filter function in Power BI.

Have a look: Power Query Add Column If Statement

Power BI DAX remove one filter

Let us see how we can remove one filter or single column filter using the Power Bi Dax remove filter function in Power BI.

In this example, I’ll use the Power bi calculate and the remove filter function to filter the data value based on condition.

  • Initially, open the power bi desktop and load the data into it, click on the new measure option from the ribbon and apply the formula below.
Single Column Filter = CALCULATE([Total],REMOVEFILTERS(Bikes[Color]))

Where,

  1. Single Column Filter = Measure Name
  2. Total = Calculated Measure Value
  3. Bikes = Table Name
  4. Color = Column Name
  • From the visualization, select the Table and slicer visual from the fields pane.
  • Then drag and drop the field values and the created remove filter measure value into it.
  • In the Slicer visual drag and drop the Bike color field from the fields pane.
Power BI DAX remove one filter example
Power BI DAX remove one filter example
  • In the below screenshot, you can see that the table visual remove filter column displays the value based on the condition applied it removes other matters except for the filtered value.
Power BI DAX remove one filter
Power BI DAX remove one filter

This is how to remove one filter or single column filter using the Power Bi Dax remove filter function in Power BI.

See also  How to Calculate Current Month and Previous Month Sales in Power BI?

Check: How to duplicate multiple columns using Power Query

Power BI DAX remove specific filter

Let us see how we can remove Specific filters using the Power Bi Dax remove filter function in Power BI.

In this example, I’ll use the Power bi calculate and the remove filter function to filter the data value based on condition.

  • Initially, open the power bi desktop and load the data into it, click on the new measure option from the ribbon and apply the formula below.
Specific filter = calculate(SUM(Bikes[Price]),REMOVEFILTERS(Bikes[Color]),Bikes[Bike Model]="220F")

Where,

  1. Specific filter = Measure Name
  2. Total = Calculated Measure Value
  3. Bikes = Table Name
  4. Color, Price, Model = Column Names
  • Now in the report section, select the table visual and card visual from the visualizations.
  • In the table visual, drag and drop the Bike Model, Bike Names, Color, and Price from the field pane. In the card visual drag and drop the created specific filter Value measure.
  • In the screenshot below, you can see that the card visually displays the value as the filtered value.
Power BI DAX remove specific filter
Power BI DAX remove specific filter
  • If we choose any other bike model value filter then it displays the value as blank as shown below:
Power BI DAX remove specific filter example
Power BI DAX remove specific filter example

This is how to remove Specific filters using the Power Bi Dax remove filter function in Power BI.

Furthermore, you may like some more Power BI tutorials:

This is how to remove filter value using the remove filter function in Power BI, Also examined the below-mentioned topics in this Power Bi tutorial

  • Power BI DAX remove filter
  • Power BI DAX remove all filter
  • Power BI DAX remove one filter
  • Power BI DAX remove specific filter
  • Power BI DAX remove visual filter
  • Power BI DAX remove page filter
  • Power BI DAX remove slicer filter
>