reverse slicer
1 Topic
Power BI Reverse Slicer (Lookup Returning Multiple Values)
Hello, I would like to build a reverse slicer in Power BI based on the two tables below: Product Category Product Name A Pencil A Pen A Ruler B Pencil B Watch C Sticker C Monitor C Ruler D Monitor D Keyboard Product Name Pencil Pen Ruler Watch Sticker Monitor When filtering (a slicer) on Product Name = Ruler, I only would like to see the result below in a matrix (because only Product Category B & D do not contain Product Name = Ruler): Product Category B D Similarly, when filtering (a slicer) on Product Name = Pencil, I only would like to see the result below in a matrix (because only Product Category C & D do not contain Product Name = Pencil): Product Category C D I tried using Lookupvalue, but it did not work because it would only return a single value. Please help. Thanks!Solved1.1KViews0likes3Comments