Stacked bars comparison in the same chart?

Hi - I’m looking to represent a comparison between current and previous year for stacked bars. Is this possible in Looker? 

628195a6-168a-464e-a46f-355c3dd998da.png

Or the only way to do this is (like below) - Stacked bar shows value for one year (e.g. 2022) and line shows value for previous year (e.g. 2021)? 

8784d9f3-b939-482d-a625-9c256442cce8.png
0 1 1,219
1 REPLY 1

If I understand your question correctly this should be feasible if you pivot by your dimension “region” (not year), and display your measures as stacked bars with the “Grid Layout by Pivot” option

90df5a0e-2a9a-498b-bfcf-be83f5f72c38.png
Top Labels in this Space
Top Solution Authors