Forum Discussion

RVK's avatar
RVK
Frequent Visitor
2 years ago

Filtering the visuals based on other filters

We are trying to solve a problem which involves following steps.

Step 1: First product slicer selection which will filter the table visual for sales related to chosen product.

Step 2: Second step need to fulfill following operations

  1. Another Product slicer selection which will capture the customers who did not purchase the chosen products.
  2. Removes the customers identified in the above step (2.i) from visual created in Step 1.

Below is the sample model

 

 

1 Reply

  • some_bih's avatar
    some_bih
    Icon for Community Champion rankCommunity Champion

    Hi RVK if your model with 4 tables: Date, Customer, Product and Sales is properly modeled and you shows data from Sales table, for customers who did not buy something their data will not be shown automatically.

    Check link for details and example