How to apply filters on Multi Choices Columns in Dynamics 365 CE

Filtering the table records for the Multi Choice fields/columns is easier if only one option is selected and can be done using the “Equal & Does not equal” filters present. But while filtering the data when more than one option is selected, the “Equal & Does not equal” filter doesn’t work as required so, in that case, we have filters called “Contains values and Does not contain values” that give you an expected output.

So let’s explore how it works!

Let’s say I have a Multi choices column called Hobbies and below are a few Account records on which I have set the data in the Hobbies field:

Here if I want to see the Account records where only the “Reading Books” option is selected then I can use the “Equal” filter.

As you can see below, after applying an Equal filter it only shows the Account record where only the “Reading Books” option is selected in the “Hobbies” column.

But if I also want to see the Account records where multiple options are…

Source link