Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
Is there any way we can sort pivot table horizontally similar to we have in Excel pivot tables? Where we can sort values based on columns instead of having columns in alphabetical order.
Cheers
Solved! Go to Solution.
Hi @Anonymous,
The Pivot table you mentioned above is called Matrix visual in Power BI, right? Currently, it is not possible to sort matrix by column headers. We can see there are only two oprions: sort by row, sort by value.
"Where we can sort values based on columns instead of having columns in alphabetical order. " For this requirement, you can refer to Matrix Column Head Order
Best regards,
Yuliana Gu
There is custom visual called TablerSorter and its very helpful in such scenarios. or Visit this link for detailed information http://blog.pragmaticworks.com/power-bi-custom-visuals-table-sorter
Hi @Anonymous,
The Pivot table you mentioned above is called Matrix visual in Power BI, right? Currently, it is not possible to sort matrix by column headers. We can see there are only two oprions: sort by row, sort by value.
"Where we can sort values based on columns instead of having columns in alphabetical order. " For this requirement, you can refer to Matrix Column Head Order
Best regards,
Yuliana Gu
Thank you so much for your help. I wil ltry indexing the columns and change the order.
Cheers
Shruti
There is custom visual called TablerSorter and its very helpful in such scenarios. or Visit this link for detailed information http://blog.pragmaticworks.com/power-bi-custom-visuals-table-sorter
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |