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

Question

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

Travis T Benjamin 20

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

Vinodh247 32,086 Reputation points MVP

2025-04-12T16:26:04.2566667+00:00
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

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.

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.
Travis T Benjamin 20 Reputation points

2025-04-12T17:53:48.0866667+00:00

So splitting the ycolumn only works on Timecharts? I am trying to do this using a barchart type of visual and I don't have the split option in the workbook chart settings. Would this be a limitation ? seems like we are going backwards from ADX.
Travis T Benjamin 20 Reputation points

2025-04-12T21:53:50.46+00:00

Ok maybe the better question is, is it possible to use ADX to Query our log analytics workspaces?
Vinodh247 32,086 Reputation points MVP

2025-04-14T16:56:07.79+00:00

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.

Accepted answer

0 additional answers

Your answer

Vinodh247 32,086 Reputation points MVP

2025-04-12T16:26:04.2566667+00:00

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

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.

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.
Travis T Benjamin 20 Reputation points

2025-04-12T17:53:48.0866667+00:00

So splitting the ycolumn only works on Timecharts? I am trying to do this using a barchart type of visual and I don't have the split option in the workbook chart settings. Would this be a limitation ? seems like we are going backwards from ADX.
Travis T Benjamin 20 Reputation points

2025-04-12T21:53:50.46+00:00

Ok maybe the better question is, is it possible to use ADX to Query our log analytics workspaces?
Vinodh247 32,086 Reputation points MVP

2025-04-14T16:56:07.79+00:00

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 1

Vinod Pittala 1,420 Microsoft External Staff

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 User's image

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.

Vinod Pittala 1,420 Reputation points Microsoft External Staff

2025-04-16T05:24:40.69+00:00

Hello Travis T Benjamin,

I just wanted to check if the above provided solution worked for you or if you need any further assistance?

Please feel free to let us know, as we are always here to help whenever you need us.

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.

Thanks
Travis T Benjamin 20 Reputation points

2025-04-17T10:23:00.0366667+00:00

Sorry for the delay in getting back, thank you for the responses I do appreciate the help very much. <3

Share via

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

0 additional answers

Your answer