Forum Discussion
Solved
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,
v-sihou-msft
Microsoft Employee
Microsoft 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,
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?