{"id":1418,"date":"2023-01-28T06:03:05","date_gmt":"2023-01-28T06:03:05","guid":{"rendered":"https:\/\/monocroft.com\/?p=1418"},"modified":"2023-01-30T05:08:47","modified_gmt":"2023-01-30T05:08:47","slug":"how-to-unpivot-columns-to-rows-in-powerbi","status":"publish","type":"post","link":"https:\/\/monocroft.com\/how-to-unpivot-columns-to-rows-in-powerbi\/","title":{"rendered":"How to Unpivot Columns to Rows in Power BI"},"content":{"rendered":"\n
Unpivoting a dataset involves converting column names into rows and their values into another column. In Power BI, you can unpivot columns to rows using the “Unpivot Columns” option in the “Transform” tab of the “Home” ribbon.<\/p>\n\n\n\n
In this article, I will take you through a step-by-step approach on how to unpivot columns to rows in Power BI Desktop.<\/p>\n\n\n\n
Let’s get started.<\/p>\n\n\n\n
To get started, the first thing to do is to insert the data in Power BI. Then Transform Data<\/strong>, which takes you to Power Query Editor.<\/p>\n\n\n\n NB: If you have multiple queries, you must select the query that contains the columns you want to transpose.<\/em><\/p>\n\n\n\n