I am working on a report for product association and a basket analysis - most commonly, products are purchased with each other. The idea is for the client to pick a product in the slicer and see a view of a table and a graph (so far). I will start with the table so you can visualize what I have:
| Picked Product ID | Picked Product Name | Associated Product ID | Associated Product Name | Associated Product Total Sales | Associated Product Quantity |
| 1 | Coke | 2 | ? | 40,00 | 5 |
| 1 | Coke | 3 | ? | 30,00 | 6 |
| 1 | Coke | 4 | ? | 30,00 | 8 |
So the issue is: I need to add the product name to the table. But of course, I already used that column, which returns the product name associated with the product picked in the slicer, which is currently being analyzed. I have a similar issue with the bar graph showing the total sales of the products by each associated item the legend shows the product ID and not the name.
How can I have the name of the associated product displayed as well? Has anyone managed to solve something like this before?
Thank you for your time!!
