Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Find articles, guides, information and community news

Most Recent
Not applicable

This blog is about how to create "AND", "OR", "NOT" filter logic using slicer visuals and DAX


Resident Rockstar
Resident Rockstar

Recently, I ran into a case where the customer required a filter on a multivalued column. However, he wanted to be able to slice based on a single value rather than the combinations of values. The solution we implemented was leveraging Power Query rather than DAX and enabled the customer to slice the data based on any occurrence in the multivalued column. This approach also makes it possible to filter in multiple columns using a single slicer!


Helpful resources

Join Blog
Interested in blogging for the community? Let us know.