In PowerBI there is a nifty trick where you can pivot or unpivot your data in the Query Editor. This saves you from having to do this in SQL or which ever source you are using for your data.

There are just 4 simple clicks to pivot your data!

First you need to select the column you want to pivot in the Query Editor, in our case being the Month column:

Next you select the Transform tab at the top and select Pivot Column:

Next you need to select what the values are, in this case its the Users column and click OK:

Then your data will be displayed as pivoted by Month as shown below:

Hope this makes your pivoting needs easier in the future!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.