Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

Filter Hirerachy

Hi Champions,


1. I have a doubt, i want to know which filter apply first.


Eg. i have calculate filed with filter, and i have visual filter too,


2. I have multiple filter in visual level , may i know

what is the hirerachy it will aplly ?


In orderwise ?




Super User
Super User

Re: Filter Hirerachy

Filters are always a logical AND, so order is not important. 

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Super User
Super User

Re: Filter Hirerachy

That said, making a selection on an actual slicer visual will undo any selection you've previously made on another slice-ish visual like a bar chart. So if you want to select both an item on a slicer and an item on a bar chart, select the slicer first unless you enjoy clicking on the same thing twice.

Moderator v-sihou-msft

Re: Filter Hirerachy



Both filters in CALCULATE() and visual filters are restricting the context of evaluation.  All filters will be applied with AND logic into your calculation. There's no order when evalutating.