Search code examples
azurekql

Kusto legend sorting

I have a piechart visualization that I'm creating through Azure workspaces. What I'm struggling with is the sorting of the legend itself. In the picture below, I'd like the legend itself to be sorted by the OSVersion value and not the count.

enter image description here

Solution

  • As per documentation, there is no option provided for legend sorting on Azure workspaces. By default legends will always sort by count in descending order. You can have look on chart-settings options.

    I tried to generate chart using sample data and got to know that it is an expected behavior.

    Query

    AzureDiagnostics
| summarize  count() by OperationName
| sort  by OperationName

    Result

    enter image description here

    Chart Settings configuration

    enter image description here