Forum Discussion

Frequent Visitor

7 years ago

Solved

How to to Create a Pivot Table in Power BI

How to to Create a Pivot Table in Power BI

General Comment

Interesting Links

Tips and Tricks

Tutorial Requests

v-danhe-msft
7 years ago
Hi sabihpk786 ,

You could refer to below data with matrix:

Sample data:

In Matrix:

Or you could use the pivot function in query editor:

Regards,

Daniel He

4 Replies

Zubair_Muhammad
Community Champion
7 years ago
sabihpk786

Try the Matrix visual in Power BI. It is quite similar to Excel's Pivot Table
- sabihpk786
  Frequent Visitor
  7 years ago
  Hello Zubair_Muhammad
  
  Thanks for the reply .could you please share me the link of this accordingly i can do this
v-danhe-msft
Microsoft Employee
7 years ago
Hi sabihpk786 ,

You could refer to below data with matrix:

Sample data:

In Matrix:

Or you could use the pivot function in query editor:

Regards,

Daniel He
PBIdashboards
Post Patron
3 months ago
The Matrix visual is the closest native option. One important limitation to know upfront: the layout is locked after you publish end-users in Power BI Service can filter and drill down, but cannot drag fields to restructure the table.
If your goal is true Excel-style pivoting where end-users can rearrange rows/columns themselves after publishing, that requires a custom visual. Flexa Tables (AppSource) is the most commonly used option for this free trial, Microsoft-certified.