Is it possible to have a chart like the one on the image? There is one bar for the previous year (selected year -1) and 4 bars (one per quarte for selected year). All data (dates and sales amount) are on the same table.
Based on your description, you want the chart to change dynamically with the selected year. As far as I know, we can't do it at this stage. It can only use the dynamic axis, but now measure can't be used as the axis.
If it were a static chart, you could do it with a calculated column on your Date table. But to make a dynamic visual (responds to year selection), you likely need to build it with the Charticulator visual so you can use a measure on the axis.