I have a simple KQL query being run against my Application Insights resource for my Container Apps:

requests
| summarize totalCount=sum(itemCount) by application_Version, resultCode
| project application_Version, resultCode, totalCount
| order by application_Version asc, resultCode asc

Which gives me these results:

What I've been trying to do is have the rows with a 5xx code be red and the ones with a 4xx code be orange, but none of the instructions I've found work.

There are no Conditional Formatting options. There is no column setting to change the render to Threshold.

Is this because I'm using my query in an Azure Dashboard and not an Azure Workbook?

I have a simple KQL query being run against my Application Insights resource for my Container Apps:

requests
| summarize totalCount=sum(itemCount) by application_Version, resultCode
| project application_Version, resultCode, totalCount
| order by application_Version asc, resultCode asc

Which gives me these results:

What I've been trying to do is have the rows with a 5xx code be red and the ones with a 4xx code be orange, but none of the instructions I've found work.

There are no Conditional Formatting options. There is no column setting to change the render to Threshold.

Is this because I'm using my query in an Azure Dashboard and not an Azure Workbook?

• azure
• azure-dashboard

• Did you try the below answer @SriBrit – RithwikBojja Commented Feb 3 at 3:04

1 Answer 1

In workbook to get row color follow below steps:

Initial Table:

Firstly, Select Grid in Visualization and then click on column settings as below:

• Then in Column Settings, Click on Column name In settings tab.
• Then click on Column renderer as Heatmap.
• Then Color palette select as Green to Red.
• We do not have individual row coloring as in ADX, so we have have to give minimum (200) and maximum (500) .
• Then In Custom number formatting --> Number Format Settings --> Units --> Count

Output: