Forum Discussion
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!!
1 Reply
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
