Forum Discussion
Slicer to filter multiple values
Yeah, what you're after is pretty straightforward, but to give more details, I would probably need to see a sample set of data. You can use a custom column in Power Query to perform that exact if/else logic across multiple columns to add an additional column that the slicer can then use.
I guess my only concern with doing it as a custom column would be if there was an overlap between a manager and a team.
So if a Customer Experience team was supposed to be in the customer experience selection of the slicer, but also had a manager that fit under the "Managed Services" selection of the slicer then only one of those two values could be declared in that custom column.
Hi Anonymous,
Can you share a sample of your data? I think we can use a measure to work with IF statements.
Best Regards,
Dale
