Forum Discussion
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/823601Hi 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.
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.
Icey Thank you for this support. I had run past unpivot while researching but didn't understand the concept at the time for whatever reason. I was then going through a Pluralsight course and had gotten to the point of seeing it in action and your reply came in so it all clicked and I have it working!