Bar chart "Normal" stacking not working as expected

[lanigit]

What happened:
We are bringing certain visualizations from one platform (ADX) to Grafana using the the Azure Data Explorer plugin. With this migration, we are noticing some behavioral differences when it comes to configuring for certain visualization types, with a possibly need to redefine or update our queries to account for platform differences.

When it comes to using Stacking with Bar chart visualization types, we are unsure as to how to get this to work with the "Normal" type. The issue being, when using a bar chart in Grafana with the ADX plugin, we do not see stacking occur when selecting the "Normal" option - bars continue to be grouped together on the X-axis, but do not stack on one another.

What you expected to happen:
When using a Bar chart visualization type, we would expect that Stacking > Normal would behave as expected, by stacking similarly grouped types of data, e.g. stack data from specific servers, which has separated stacks by application ID, in the same bar.

How to reproduce it (as minimally and precisely as possible):

1. Create a query that can be summarized or grouped together by a feature, percentile, time period, etc.

Example query

TableName
  | where Timestamp > ago(1h)
  | where Application == "<VALUE>"
  | summarize NumExecutions = count() by bin(Timestamp, 1h), Site, AppName, AppId

2. Select Visualizations dropdown > Bar chart
3. Confirm X axis is correctly defined
4. Under Stacking, choose Normal (this is where we see the issue from the screenshot below)
5. We also tried playing with the "Format as" option in the code editor between Table, Time series, etc., but still couldn't get stacking to work
6. For the most part, stacking does not occur and we can't find a consistent way to ensure "Normal" stacking works (see comparisons between platforms in screenshots below)
   Screenshots

Attempting "Normal" stacking in a Bar chart in Grafana

Attempting "Normal" stacking in Bar chart in ADX

These charts are powered by the same queries, so we're wondering if there is a configuration change we should be making.

Anything else we need to know?:

Environment:

• Grafana version: 10.4.11
• Plugin version: Azure Data Explorer Datasource v5.0.5
• OS Grafana is installed on:
• User OS & Browser: Mac Sequoia 15.1.1 / Chrome 131.0.6778.86
• Others: