Basket Analysis with Power BI

[hdsogno]

I'm new to Power BI.  I'm trying create a chart that will show what other products customers buy along with the product chosen in a slicer.

Table looks like this:

Customer                 Product                   Sales

#1                              Apples                      $5

#1                              Grapes                      $5

#2                             Bananas                     $5

#2                             Milk                           $5

#2                             Bread                         $5

#3                             Apples                       $5

#3                             Steak                         $40

If Apples is chosen in the slicer can a chart be made to show:

2 customers bought Apples totaling $10 in sales and they also bought:

Grapes totaling $5 in sales and Steak totaling $40 in sales 

Any help will be much appreciated.

[amitchandak · Accepted solution]

Refer this can help

https://community.powerbi.com/t5/Desktop/Basket-Analysis-with-Power-BI/m-p/649017