How to create a fake id to get rid of big gaps in line chart

[LotteLaugesen]

Hi 
How can I make a fake id to get rid of this

and make it look like this but with out the scroll bar

Is that possible?
The first chart is continuous and the second is categorical.

BR

Lotte

[LotteLaugesen]

Thank you all for your help, but now the user want something else 😉

[Anonymous]

Hi @LotteLaugesen 

Please check the following possible solution:

I tested with simple data and the table looks like this:

1. Create a new table to fill in the big gaps of ID.

NewTable = 
SELECTCOLUMNS(
    ADDCOLUMNS(
        GENERATESERIES(9105, 10765, 5),
        "Y", ROUND(RAND() * (75 - 74.5) + 74.5, 2)
    ),
    "X", [Value],
    "Y", [Y]
)

 2. Union the new table with the original table into a new table.

CombinedTable = 
UNION(
    SELECTCOLUMNS('Table', "X", 'Table'[X], "Y", 'Table'[Y]),
    SELECTCOLUMNS('NewTable', "X", 'NewTable'[X], "Y", 'NewTable'[Y])
)

3. Create a Line Chart with the CombinedTable.

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Attaluri]

Hi,
Try creating column in your model with below definition. 

=RANDBETWEEN(70,75)