A Reverse Slicer in Power BI

The table contains customer names, purchased products, and the company’s profit. In Power BI, when I choose a specific customer using a slicer, I want to display the top 3 products that the selected customer did not purchase. This functionality should work as an inverse filter and can be valuable for recommending products to the customer based on their preferences.

Inverse Slicer.pbix (23.9 KB)

Hi @christina.weber ,

Use a trick - in measure use if =Blank then 0 and filter 0 afterwords.
(maybe to add additional top x but you need to define precise algorithm for ranking)

PBI file:
Inverse Slicer v1.pbix (24.3 KB)

Hope it helps and what are you looking for.

1 Like