562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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!
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:
We'll apply an unpivot transform to generate one row for each value in the Excel spreadsheet.
Finally, I'll use this data to derive the following chart:
I'll show (in summary) how to create this stacked column chart.
Let's start with importing the data!
You can download the file yourself if you want to follow along!
|Parts of this blog|
25 Aytoun Street