Line chart X axis issues - (week) showing earlier data points not present in the dataset

[MZqlik]

Hi There,
On my dataset I have a constrain that only shows dates after 31/03/22.

As you can see, when I hover over the first data point it shows that the date is 01/04/22 - I am wondering why the Line chart X axis which is a week ending number is showing 27/03/21.

I had a look and I can confirm that in the data I don't have anything earlier than 01/04/22.
Does anybody know how I can achieve this?

[Alex_Whatever]

Try not to use a Continuous scale

or

Add-ons -> Data handling -> Include zero values -> turn off

or

Also, if your [Date] field comes from a separate Calendar table, please make sure you are using "Where Exists()" / "Left Keep ()" / "Where [Date]>=" construction in the script. And check an existed values in the Data Model.

[MZqlik]

If I take off the Continuous scale the 27/03/22 disappears but I get some gap at the beginning. It is very odd.

Would you know how to get rid of it? 

[romansysyuk]

as you can see, there is not enough space for the dimension values:

a) make the chart higher;

b) use VizLib object with option to set amount of dimension values characters;

c) Presentation.Scrollbar = Mini chart; Presentation.Scroll alignment = End; X-axis.Label orientation = Horizontal; X-axis.Number of axis values = Custom; X-axis.Maximum number = {an amount which gives you full dimension values shown without ...};

But! At the very beginning I'd not switch off Continuous scale but rather checked twice a data quality (marked bold in my previous post)

[MZqlik]

Hi there,
It's not a matter of making the chart higher; even if I make it bigger, the x-axis stays the same.