Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Create Continous Line Chart

I have a line chart in which I am showing a 30 day window and I have created a text column called Month Abbreviation Day in my date table that looks like Jan 1, Jan 2 ...


I have a data set that won't have data on every day but I want the line to be continous.   It appears continous on works with dates.  How to I make my column a date column and have it in the format of "MMM d" ?


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 (
            ContinuousLineChart[Date], DimDate[Date]
        <> BLANK (),
        ContinuousLineChart[Date], DimDate[Date]

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.


Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not applicable

v-yulgu-msft, Thanks for the quick respone!


I have the data (Calendar) table established but what I am missing is how to format the date column with a custom format like "MMM d" for the X-Axis.    The format drop down doesn't have this as an option and I am not sure where I can change the format string?   Can you point me in the right direction for this?


Also my observation was that if I saved a calculated column in text format, that the Line Graph would only support this as categorical type for the X-Axis.  Taking a some time for me to understand the differences in Power BI charting as compared to Excel.   


Thanks for your help!

Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.