Product name for a legend and table
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!!