This page has 0 threads | Add post

Blogs

Many people around the world enjoy and benefit from our blogs. If you're one of them - and can afford to - please make a small donation to help keep this and future blogs, exercises, skills assessment tests, tips, tutorials and videos freely available to everyone!

How to use an unpivot transform in Power BI Desktop Query Editor Part one of a three-part series of blogs
If you get data in pivot (two-dimensional) form, you can unpivot it to get the underlying rows, and hence produce charts and visuals. This blog shows how! Unpivoting data in Query Editor: a case study (this blog) Transforming data using UNPIVOT Creating a chart based upon the transformed data

How to use an unpivot transform in Power BI Desktop Query Editor

Part one of a three-part series of blogs

If you get data in pivot (two-dimensional) form, you can unpivot it to get the underlying rows, and hence produce charts and visuals. This blog shows how!

Unpivoting data in Query Editor: a case study (this blog)
Transforming data using UNPIVOT
Creating a chart based upon the transformed data

Posted by Andy Brown on 04 January 2018

Unpivoting data in Query Editor: a case study

This blog shows starts with a simple spreadsheet of data in Excel:

The source data for this case study.

I'll show how you can load this into Query Editor (you could use either PowerPivot or Power BI Desktop; for this blog we'll use the latter), and then transform it to get this: