Forum Discussion
Slicer to filter multiple values
If it wasn't only always going to me me, Jim John and Bob would there be anything I could do?
Sort of what I need is almost an if then statement for a slicer. Like if Engineering Projects is selected then filter on these managers.
If Manufacturing is selected then filter on these teams.
Is there any way to do this in powerbi currently?
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
