How to create Pivot Tables in Power BI

Question

Can anyone specify how to create Pivot tables in Power BI?

Answer 1

Hey,

First of all, there is no "Pivot table" in Power BI, but there is a "Matrix Visualization", which is equivalent to a Pivot table in Power BI.

Let's take a look at how to create:

• Select the Matrix Visual But NOT the Table visual.

*Matrix visual is equivalence to Pivot Tables.

•  You’ll get similar options as you do in Excel i.e. Rows, Columns and Values​

If you wish to master Power BI Concepts, Check out Power BI Training Topics now!