Forum Discussion
Pivot table (like excel) dashboard in Power BI?
Hi
Is there a way to create Pivot table (like excel) dashboard in Power BI?
If yes, Could you please help with steps?
Regards
Sanket
As Greg_Deckler said, to render data like pivot table in Excel, you can use Matrix.
If you need to add filters like pivot table, you can use slicer visual for selection to filter data.
Regards,
11 Replies
- Greg_Deckler
Community Champion
You would use the Matrix visualization. Third row, farthest right.
v-sihou-msftMicrosoft Employee
As Greg_Deckler said, to render data like pivot table in Excel, you can use Matrix.
If you need to add filters like pivot table, you can use slicer visual for selection to filter data.
Regards,
Thank you. But how can we sort data by the first column? As you can see in your example, the calendar years are not sorted in the right order.
- IanCockcroft
Post Patron
@YingHuan
RE ordering
In the query editor, sort the column or sort my another column. [YEAR] for instance which is an INT
??
How about grouping, like Excel?
I have a matrix setup and want to group products together, like I would in an Excel pivot table so that their data is aggregated and shows under the group name that i stipulate. I tried cntrl+ clicking the two rows I want to group, then right-click, but there is no menu option to Group. Any ideas?
Hello. I have a matrix setup and want to group products together, like I would in an Excel pivot table so that their data is aggregated and shows under the group name that i stipulate. I tried cntrl+ clicking the two rows I want to group, then right-click, but there is no menu option to Group. Any ideas?
- DavidAnthony
Helper II
Yes — there are 3 main ways:
Matrix Visual (built-in)
Use Rows, Columns, Values — like Excel Pivot.
Add subtotals and drill-down for hierarchy.
Field Parameters
Let users switch rows/columns dynamically.
Great for interactive dashboards.
Flexa Tables (custom visual)
True Excel-like Pivot experience in Power BI.
Drag & drop fields, compare variances, manage totals easily.
Free on Website: Flexa Tables
- PBIdashboards
For the grouping use case mentioned in the recent comments: Power BI's Matrix visual doesn't support manual row grouping like Excel pivot tables (Ctrl+click to group). The workaround is creating a grouping column in your data model.
If the goal is true Excel-style pivot behavior including drag-and-drop restructuring and custom groupings after publishing Flexa Tables on AppSource handles this directly in Power BI Service. Users can group, restructure, and add variance columns without going back to Desktop. Search "Flexa Tables" on AppSource, free trial available.
