Create reference between 2 tables where the rows in table 1 match the column headers in table 2

Better you Unpivot the tables having the row data in the column and then try

https://radacad.com/pivot-and-unpivot-with-power-bi

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

Hi Jason_Apt ,

Can this meet your requirements?

Steps:

1. In Power Query Editor, select "PlayerName" column and then "UnPivot other columns".

2. Close and Apply.

3. Create a line chart.

4. Create PlayerName slicer and Time Slicer.

For more details, please check the attached PBIX file.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.