Pivot Tables in Power BI

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. 

2 Comments

  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

Comments are closed.