I’d like to present data, where counts for A and B are stacked for each year. In other words, there will be a vertical bar for each year along the X-axis, and each bar will show stacked counts for A and B. Is this possible to do? Everything I have tried gives me just one (non-stacked) vertical bar.
It sounds like you tried using a “Chart” query. You’ll have to use a “Metric” query instead to do this. You’ll have two columns, one for A values, one for B values, and one “Group By” column for the year, set to horizontal or vertical stacked bar.