Line chart issue - data gaps

Question & Answer
, , , , , ,
1

Hi,
when i’m using line chart and having data gaps for specific month then not each month is displayed on x-axis as below:

image
image1653×417 36.2 KB

However when “Show date gaps” option is switched on, each month is displaying:

image
image1717×427 36.4 KB

Is there any way to avoid gaps and have all the months displayed on x-axis?

Thanks in advance for any hints.

2

Hi @Rad
did you checked out the x-axis area?

grafik
grafik258×514 15 KB

BR

3

@ErikG i checked (as per 2nd screenshot in my post) but i don’t like the final output

4

So you are looking for something like:

grafik
grafik1193×642 26.6 KB

5

@ErikG exactly, how to achieve this?

6

With an ugly workaround.
These are actualy your two visuals overlaped.

7

@ErikG I see but not really sure how to overlap those in QS

8

You have to use free form sheet style and disable the background of the visual on top.

9

@Rad

Have you tried the “Missing data” option?

image

10

@David_Wong That was my first idea, too. But I tested it by myself and doesn’t changed anything.

11

@ErikG It looks like the “Missing Data” option doesn’t work if both the date on the x-axis and the value on the y-axis are missing. The “Show date gaps” option just adds the missing dates at the visual level. For the “Missing Data” option to work, all the months have to be in the dataset even if they don’t have any value.

@Rad
Are you able to join with a date dimension table that contains all dates in your date range? When you create your visual, put the date from the date dimension table on your x-axis. The “Missing Data” option will work if you do that.

1 Like
12

@David_Wong let me test it