Issue with Column Order in Azure Monitor Dashboard Visualizations

Miller, Kevin (External) 20 Reputation points
2024-06-06T19:14:54.7533333+00:00

Hello,

I am experiencing an issue with arranging the order of columns in my Azure Monitor dashboard visualizations. Despite various attempts to control the order of columns through the query, the columns do not display in the specified order in the visualization.

Here is a simplified version of the query I am using, In the visualization, the SuccessfulRequests column appears before the RequestsCount column, despite specifying the desired order in the query.

Could you please provide guidance on how to enforce the correct order of columns in the visualization? Are there specific settings or query adjustments needed to control the order of columns in Azure Monitor dashboards?

Thank you for your assistance.

ContainerLog
| where LogEntry contains "Sample Request" and LogEntry contains "TESTENV"
| summarize RequestsCount = count() by Day=format_datetime(TimeGenerated, "MM-dd")
| join kind=leftouter (
    ContainerLog
    | where 
    (LogEntry contains "Error Type 1" or 
    LogEntry contains "Error Type 2" or 
    LogEntry contains "Error Type 3" or 
    LogEntry contains "Error Type 4" or 
    LogEntry contains "Error Type 5") and LogEntry contains "TESTENV"
    | summarize ErrorCount = count() by Day=format_datetime(TimeGenerated, "MM-dd")
) on Day
| project Day, RequestsCount, SuccessfulRequests = RequestsCount - ErrorCount
| order by Day asc
Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,971 questions
0 comments
Accepted answer
  1. Abdul 2,275 Reputation points Microsoft Vendor
    2024-07-03T11:04:55.71+00:00

    Hi @Miller, Kevin (External),

    Since the Microsoft Q&A community has a policy that the question author cannot accept their own answer. They can only accept answers by others, Summarized and posted the solution that you shared, request you to Accept the answer, it will benefit the community find the answers quickly.

    Scenario:

    Issue with Column Order in Azure Monitor Dashboard Visualizations

    Issue:

    Despite specifying the desired order in the query, the columns in the visualization are not displayed as expected.

    Things Tried:

    Arranging the order of columns in Azure Monitor dashboard visualizations can be challenging, file generated by the script has columns arranged in alphabetical order.

    Shared by @Miller, Kevin (External)

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Clive Watson 5,951 Reputation points MVP
    2024-06-07T15:28:17.9866667+00:00
  2. Miller, Kevin (External) 20 Reputation points
    2024-06-07T18:31:36.54+00:00

    I figured it out. It seems the columns are arranged alphabetically. I spent a whole day trying to get them to rearrange lol!

    0 comments