How to use OR operation between filters in Power BI

[Anonymous]

Hello, 

We are in the proces of migrating our reports from Oracle BI to Power BI and i'm trying to apply a filter that looks similar to the image above. Right now Power BI filters only allow And operation when i add two filters. Is there a way we can add OR operation to get data between either of two different date fields.

Thank you!!

[v-yuta-msft]

Hi Sharathp,

You can use OR logic in your dax measure, you can also refer to this blog: https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/.

Regards,

Jimmy Tao

[Anonymous]

Thank you @Anonymous and @v-yuta-msft fro the prompt reply, i'm trying to implement this to some text data with no measures, i tried to resolve this using an example mentioned in the weblink  https://stackoverflow.com/questions/49738761/how-to-set-or-logic-between-two-slicers-for-the-attributes-from-same-dataset. i'm able to replicate the solution with same data but not with my data. Attached are two pbix files with sample data from above example and my data.

Working solution with sample data: https://drive.google.com/open?id=1v9FEHll5eubLsE3mTuG_b-PbV5SMLZyx

My sample data: https://drive.google.com/open?id=1kYbaMe752VUwI9u-fj12Z2Pe_lp_NDNo

Sharath

[Anonymous]

@marcorusso has written a blog article on his site www.sqlbi.com

You can read about his solution here: Using OR Conditions in Slicers in DAX