Paginated report filtering power bi report builder on sharepoint choice column

[cheezy]

I have a few paginated reports that i am trying to filter on values from a multiple selection choice field in sharepoint.

I have a filter on my dataset that looks at the sharepoint field but only returns records if the choice field only has that selection only. If any other selections in the choice field the records are not return.

for example 

field 1          field 2

record 1        A

record 2        A,C

record 3        C, D

my dataset filter expression is  A in [field 2] but only returns record 1 not record 1 and 2

any advice appreciated thanks

[amitchandak · Accepted solution]

@cheezy , best is split field 2 into rows based on delimiter in power query. If possible, in this case.