563 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 three 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 assumes that you know how to use Power BI Desktop, and just gives the summary steps to follow to create our chart. First choose the stacked column visual:
Choose this visual.
Choose fields to show in your chart:
Either drag the fields into the field well, or select them in the list.
You should now be looking at a chart like this:
A basic stacked column chart.
I then changed the Legend and Title properties, among others:
|Legend properties||Title properties|
I've also added a Y axis title and a border to the visual to get the final chart:
The final chart, in all its glory!
A final thought: if you could only get your IT people to provide the data in its raw form, you wouldn't have to unpivot it!
|Parts of this blog|
25 Aytoun Street