This, really short, manual is about creating of Pivot Tables in Power BI. Actually, it is very similar to Pivot tables in Excel.

Lets work with this sales data:

Insert a new visual called Matrix. Add the items to Rows, Columns and Values – the same way you do it in Excel. 


  1. That is called “repivoting” data and is NOT a pivot table. A user cannot move dimensional data from rows to columns and visa versa nor can they nest a hierarchy. Very deceiving.

  2. How to sort this by column. Only thing why Im not using PowerBI

Leave a Reply

Your email address will not be published.


clear formPost comment