top of page

Changing table structure in Power BI

Updated: Aug 2, 2023

When preparing your data for analysis in Power BI usually the first step is to prepare and clean the data before creating semantic layer (eg. measures, finctions etc). In this case we see a matrix table with attributes values in columns:



What is the best way to create pairs like this and re-shape the table?

  1. Switch to Power Query (Transform Data)

  2. Select columns in the table which you want to unpivot

  3. Select Unpivot

  4. Rename the 2 new columns to give a meaningful name

  5. Close and apply


Now you won't see the years in column headers but as values



Recent Posts

See All

Comments


bottom of page