How to have Multiple ycolumns in KQL charts like you can with ADX

Question

Per title, we'd like to create charts in our environment so we can either have multiple ycolumns or leverage the ysplit option like we could in ADX. Can anyone provide any details / syntax how this is done in Azure Workbooks when we query our Log Analytics workspaces?

I was able to accomplish this in Azure Data Explorer but I'd like to know if the functionality also exists some where in Azure workbooks too.

Many thanks.

T.B

Answer 1

Hello Travis T Benjamin,

As Vinodh247 mentioned the split by option is not supported for bar chart.

Ok maybe the better question is, is it possible to use ADX to Query our log analytics workspaces?

And for the asked query, Yes you can query your Log Analytics workspace using Azure Data Explorer query tools and in a cross-service query.

Please refer to the below article: https://learn.microsoft.com/en-us/azure/data-explorer/query-monitor-data

Please let me know if you face any challenge here, I can help you to resolve this issue further

Please provide your valuable comments

Please do not forget to "Accept the answer” and “upvote it” wherever the information provided helps you, this can be beneficial to other community members.it would be greatly appreciated and helpful to others.

Answer 2

Yes, you are rightg that the “split by” (ysplit-like) option in azure workbooks is only supported on time based charts, such as Time charts or Time series line graphs. If you switch the visual type to bar chart, column chart, or pie chart, the “Split by” feature disappears. This is indeed a limitation in the current workbooks experience.

Answer 3

Hi ,

Thanks for reaching out to Microsoft Q&A.

In Azure Workbooks, when querying Log Analytics workspaces using KQL, you can visualize multiple Y axis values in a few ways, though it is not as flexible as ADX dashboards. Here is a breakdown of what is and is not possible:

Options Available in Azure Workbooks

1. Multiple Y columns in Time Chart (Line Chart)

• You can include multiple Y series (columns) in a time chart.
• Use a query that returns a timestamp column and multiple numeric value columns.

2. Using ysplit or split by equivalent

Azure Workbooks does not support ysplit like ADX dashboards. However, you can emulate this by:

• Using split in the chart configuration UI: configure "Split by" to plot each value in its own mini-chart.
• Or, create multiple tiles in a workbook, each visualizing a subset of the data.

Limitations Compared to ADX Dashboards

No true ysplit for separate Y-axis per column in a single chart panel.

Dual axis charts (two Y-axes, left/right) are not available in Azure Workbooks.

Custom visual layout (like in ADX dashboards) is limited. Workbooks are focused on basic monitoring, not high-end visualization.

Please feel free to click the 'Upvote' (Thumbs-up) button and 'Accept as Answer'. This helps the community by allowing others with similar queries to easily find the solution.