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,
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
??
