Joel Clark on 01 Mar 2021 14:14:45
By default, filters on the filter pane work together in an 'AND' format so that all filter conditions are applied. It would be really useful to be able to group two or more filters into an 'OR' arrangement.
For example, if hair colour and shoe size are held in different columns (as one would reasonably expect) then to select results where shoe size >5 OR hair colour is brown you need to have control of the model in order to create something that can do this in DAX or Power Query.
It feels like there should be some simple report-level setting where filters can be grouped together so a user can select either AND / OR as the chosen operator for that arrangement without having to edit or develop the model.