A Reverse Slicer in Power BI

Power BI
1

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.

image
image1414×484 17.4 KB

Inverse Slicer.pbix (23.9 KB)

2

Hi @christina.weber ,

Answer:
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