Forum Discussion
Solved
Pivot sort
Using the "pivot" command, there doesn't appear to be a way to sort the columns... am I wrong? For example: Table | project Column_A, SomeValue | where SomeValue > 0 | evaluate pivot(Column_...
hdsheena , ScottAllison - you can now use project-reorder to set the order you want, and if column names are not known (since the data set here is dynamic) you can use asc / desc.
Interesting. I'm using this for a dashboard tile at the moment.
Noa Kuperberg
Microsoft
MicrosoftHey, verified that and indeed no way to control the order of the pivot-based columns :/
Enhancement request! :)
Seconding the enhancement request, and thank you for this post as it was exactly what I was looking for!
- Noa Kuperberg
hdsheena , ScottAllison - you can now use project-reorder to set the order you want, and if column names are not known (since the data set here is dynamic) you can use asc / desc.
