Power BI Power Query: Unpivot Columns

Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to unpivot columns in Power BI Power Query

Unpivot Columns translates all but the currently unselected columns into attributes -value pairs. We want to unpivot the data in the Power BI Power Query of the caption below

To unpivot other columns:

Select Qtr 1 to Qtr 4 columns

In the Transform group of the data tab, click on Unpivot Columns

We can see that all the Account Managers name are listed in alphabetical order as well as the corresponding Q1 to Q4.

Posted in Blog.

Leave a Reply

Your email address will not be published. Required fields are marked *