The source data is correctly displayed in the table visual.
VDT incorrectly shows the data as being in consecutive months.
We do not have time mapping in ValQ, so the better suggestion would be to create a dim table with twelve months.
Create a join between your table and newly created time dim table.
Use the time from time dim table in the period section and this should help you to solve this issue.
Steps to get the correct result:
- Pivot the year column along with the value column that you have in the Query Editor to get 3 data series (2018,2019,2020).
2. Add these data series to the Value field under Visualization pane.
3. Select the year from the series dropdown to get data in the appropriate period.