Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello - I have a large data set of individuals each with five traits associated with them from a list of about 40 traits. I'd like to use a slicer to select traits and identify individuals with those traits. Right now if I select two traits using the slicer and the ctrl button - I get a list of individuals with either of the traits instead of a list of individuals with BOTH of the traits - am I overlooking something simple?
Solved! Go to Solution.
HI @AA364,
In fact, these filter work as expected. The default filter/slicer does not support this type of filter interaction.
You need to create a Dax expression to extract the selection from filter and check the row content to return flag. Then you can use this on visual level filter to filter result flag to indirectly achieve AND logic on the filter selection items.
If you are confused about coding formula, please share some dummy data to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
HI @AA364,
In fact, these filter work as expected. The default filter/slicer does not support this type of filter interaction.
You need to create a Dax expression to extract the selection from filter and check the row content to return flag. Then you can use this on visual level filter to filter result flag to indirectly achieve AND logic on the filter selection items.
If you are confused about coding formula, please share some dummy data to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng