Azure workbook filtering based on a selection/click in a chart

Question

I would like to filter the data and show the raw/aggregated data in a table/grid when a selection is being done in a Bar Chart in Azure Workbook visualizations.

I have a bar graph as below. When I select on the "purple" line denoting Avg CPU to be very high, I would want a grid/table showing the CPU aggregated on x based on the query. How can this be achieved in Azure workbooks.

Answer 1

Yes, it can be done. see the azure docs or the github docs for full details but in general:

1. in the advanced settings for the visualization, choose the "when items are selected export parameters" option, and fill that out. (note in both docs it calls out that in grids you can export any column in the grid, but in charts, you have different options for x, y, series, etc)

   that will create a parameter with a value when something becomes selected

2. use that parameter downstream, in query text, or in conditional visibility to hide and show other steps