Slicer/Filter Mixed Data

[Amanda_44]

Hello,

In a finance dashboard, I have a column that lists multiple funding sources, including combinations. Example rows:

Fund A

Fund B

Fund C

Fund A and Fund C

Fund B and Fund A

How can I create a slicer that will allow a user to choose all rows with a particular funding source, no matter how it’s listed?

I'm a newer user and appreciate any help, thank you.

[Ashish_Mathur]

Hi,

In the slicer, click on the 3 dots and select search.  Type Fund A there

[lbendlin]

Replace " and " with "|" and then use PATHCONTAINS to test if a fund is included or not.