Forum Discussion
Power Pivot - Duplicate Column Values
SergeiBaklan Thank you for your reply. An example is attached.
There's one table that lists all of my different fields in one column and the corresponding category (that I would like to toggle with a slicer) with in the other column.
Another table has those fields labeled as column headers in the top row with the values below. Each row corresponds to a different product (size).
Including screenshots of the tables and my relationships.
If I understood correctly you'd like to build relationship between columns in Networking table and list of these columns in another table. If so it doesn't work. You need to unpivot Networking table and work with it, Power Query will the best tool for that.
However, it's not clear what is the final result you'd like to achieve, relationships is only of of the means.