In which order are filters and slicers applied

[Anonymous]

Hi,

I would like to know in wich order filters and/or slicers are applied. 

E.G., if there is a filter on a column - e.g. fairytale text -  like contains "Pinoccio" and there is a slicer on date created. 

If I select a single day in the slicer, I evidently would prefer the slicer to go first and then do the contains, since a contains will go through all the rows/column and is slow by nature.

So, is there a way to instruct PBI to the order of which filters are applied? 

[Anonymous]

Hi,

Thanks for the prompt reply. 

The background of my question is that we use the Text Filter custom viz and that does indeed cause performance issues when used over large datasets (app 4M rows). Even when setting the date slicer to one day, it still takes a lot of time to search text. So, I wondered whether the text filter search goes first and then the slicer is applied, if so, it will never be fast I am afraid. 

[selimovd · Accepted solution]

Hey @Anonymous ,

for a standard behavior you cannot change the order how the filters are applied.

In a DAX measure you do that by considering one filtercontext first and then another one. But in general try to avoid interating functions if they have to do a complex operation on a row level. Usually there are other alternative approaches to get the same result.

Do you have any performance issues? If you post your DAX code I can take a look.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic