cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dataguy Member
Member

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" ?

2 REPLIES 2
v-yulgu-msft Super Contributor
Super Contributor

Re: How to Create Continous Line Chart

Hi @dataguy,

 

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. 
5.PNG

 

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

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.
dataguy Member
Member

Re: How to Create Continous Line Chart

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

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 473 members 4,513 guests
Please welcome our newest community members: