Error when there are blank periods of data, expect to see data in the correct month.


The source data is correctly displayed in the table visual.
VDT incorrectly shows the data as being in consecutive months.

Answered question

Hello Peter,

Steps to get the correct result:

  1. 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.

Posted new comment

Hi Varoothini,
I cant see this as a workable solution as you don’t always have the ability to remodel the data – We often use SSAS cubes as a source.

I’ve also been able to replicate this issue in one of the Valq demo exercises where the data is modelled similar to this suggestion.

I suspect the resolution is to create zero value fact records to fill the blanks. 🙁

Hello Peter,

In case you aren’t able to remodel the data, DAX measures can be of help to overcome this issue. With DAX you can create a measure for each year as data series using CALCULATE.

You are viewing 1 out of 2 answers, click here to view all answers.