How to Create Continous Line Chart

Hi Anonymous,

What do you mean continuous line? Do you want to display data points on each day in the line chart even though there is no data record on some specific day? 

If that is the case, you need to create a Calendar table to show continuous date on X-axis. Below is my test result.

Create a calendar table.

DimDate = CALENDAR(DATE(2017,1,1),DATE(2017,1,31))

Insert a calculated column in calendar table and lookup the values which are added into Y-axis from dataset table. 

DimSales =
IF (
    (
        LOOKUPVALUE (
            ContinuousLineChart[Sales],
            ContinuousLineChart[Date], DimDate[Date]
        )
    )
        <> BLANK (),
    LOOKUPVALUE (
        ContinuousLineChart[Sales],
        ContinuousLineChart[Date], DimDate[Date]
    ),
    0
)

Then, create line chart as below. 

By the way, you said you created a text column called Month Abbreviation Day in date table and now you want to convert this column to date column in format of "MMM d", right? You can directly create a calendar table which contains continous date column and the date displays in "MMM d" format on axis by default, as is show in the image above.

If I have something misunderstood, please correct me and share the screenshots of your report design and expected output. And please provide some sample data so that I can reproduce your scenario.

Thanks,
Yuliana Gu