Power BI Tutorial - How to Unpivot data in Power Query
Learn how to Unpivot data in Power Query within Power BI in this Power BI Tutorial. Have you ever wondered how to unpivot data in Power BI, well in this tutorial I show you how you can do this in Power Query using; Unpivot Columns, Unpivot Other Columns and Unpivot Only Selected Columns.
Can you think of a scenario where you might use Unpivot Only Selected Columns in Power BI.
To follow along copy and paste the below in to Notepad or Excel:
Category,2017,2018,2019,2020,2021
Appliances,50984,53533,58886,67719,81263
TV/Audio,100543,105570,116127,133546,160255
Computing,80428,84449,92894,106828,128194
Gaming,12593,13222,14544,16726,20071
Cameras,6936,7282,8011,9212,11055
Phones,18005,18905,20795,23915,28698
![I broke your phone bro[animation]](https://images.mixrolikus.cc/video/ftL6z81T_Cc)
