Azure Monitor Workbooks unable to read parameters on graphs

[mwolterw]

I'd read the article to set interactive parameters  and it worked for Grid, Tiles and Graph, but when I pick another visualization, it won't work. This happens with all the tables I'd try.

One of the queries I am using to export parameters:

SecurityAlert 

| where TimeGenerated {TimeRange}

| summarize count() by AlertSeverity

Fig. 1- Parameters setting:

Query I use to project the exported parameters:

SecurityAlert 

| where TimeGenerated {TimeRange}

| where AlertSeverity =='{P_AlertSeverity}' or 'All alert severities' =='{P_AlertSeverity}'

| summarize Count=count() by CompromisedEntity, Severity='{P_AlertSeverity}'

| top 5 by Count

Fig. 2- As a Grid, it works (as well as Tiles and Graphs):

Fig. 3-When I select the Pie chart (Or any of the Bar charts), it won't work:

Fig. 4- If I go to the Chart Settings and I change the "Legend Settings" to "Show series legend" is the same, but if I unselect the legends, I am able to capture the default value:

Where do I need to set the parameters to click over the Low, Medium or High and get the list I see in the Fig. 2- ?

It works on Grid, Tiles and Graph, it doesn't on in Pie and Bar charts. Didn't try with the others.

Thanks.

[#2 · Accepted solution]

@mwolterw 

You need to export the "series" or "x" or "y" for Charts.  

You can then use the exported parameter in a following Query, e.g.

LAQueryLogs
| summarize dcount(QueryText) by '{expRequestClientApp}'

[#3]

@CliveWatson It worked great, many thanks!