Tutorials

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.

Trey Drier says:

3.12.2018 at 22:26

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.
Anonymous says:

14.4.2019 at 18:56

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

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.