Forum Discussion
Slicer/Filter Mixed Data
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.
Hi Amanda_44 ,
Thank you for the update. Please provide the sample data, i will explain step by step in detail, that will help you to resolve your issue.
Regards,
Dinesh
7 Replies
Replace " and " with "|" and then use PATHCONTAINS to test if a fund is included or not.
Hi,
In the slicer, click on the 3 dots and select search. Type Fund A there
Hi Amanda_44 ,
Thank you for reaching out to the Microsoft Community Forum.
As you mentioned in your Question, you want to create a slicer that will allow a user to choose all rows with a particular funding source.
Please refer below steps.
1. Created sample data. Please refer below snap.
2. Please refer output snap and attached PBIX file.
If you want to select “Fund A” in slicer and see all rows containing "Fund A", even if the data says “Fund A and Fund C.”
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
Hi Amanda_44 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
Hi v-dineshya,
I appreciate the responses. I was not able to get it to work, but that is probably due to my skill level. I was not able to successfully complete step one with the sample data.
