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!

Some other pages relevant to these blogs include:

You can also book hourly online consultancy for your time zone with one of our 7 expert trainers!

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! Unpivoting data in Query Editor: a case study Transforming data using UNPIVOT Creating a chart based upon the transformed data (this blog)

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!

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

Posted by Andy Brown on 04 January 2018

Creating a chart based upon the transformed data

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: