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