cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ciarangreene Frequent Visitor
Frequent Visitor

Non-continuous line chart data

Hi,

 

I have a table consisting of a date with four value columns which I've charted. Here:

PowerBIChart.png

 

I may not have all four values for every date, and when this happens, I don't want that part of the line to render. Excel handles this as I would like:   

ExcelChart.png

 

Is there any way of configuring Power BI not to interpolate and render a line for missing data?

 

Also; I've noticed that the 'values' for a chart always have some sort of aggregation (Sum, Count, Avg, etc). Is it possible to just chart the raw data values?

 

Thanks,

Ciarán

13 REPLIES 13
HarrisMalik Established Member
Established Member

Re: Non-continuous line chart data

@ciarangreene I think what you are looking for is Categorical axis. You can open the format tab while selecting the visual and in X-Axis change the type from continious to categorical. I hope this helps you.

 

Categorical.jpg

ciarangreene Frequent Visitor
Frequent Visitor

Re: Non-continuous line chart data

@HarrisMalik Ah! Sweet. It's an improvement, thank you, but this results in a scroll bar appearing for the X-Axis whereas I'd like to see everything at a glance.

HarrisMalik Established Member
Established Member

Re: Non-continuous line chart data

@ciarangreene The scroll bar normally appears when you have too many members on an axis. Can you share a screenshot?

ciarangreene Frequent Visitor
Frequent Visitor

Re: Non-continuous line chart data

@HarrisMalik Unfortunately I can't share a screenshot... I'm getting an error message: "Uploading PowerBIScreenshot.jpg resulted in the following error: You have already uploaded 1,000 images during this 24-hour window. You can try to upload more images later." This comes as a bit of a surprise as I've only uploaded 2... ever. This isn't a PowerBI issue... its just kind of funny.

 

The scrollbar only appears when I altered the axis to categorical. I could potentially average by week which would reduce the rows to 52, but I'm loosing granularity. Is this my only option?    

 

The data table I'm using has 366 rows, a date column from 2015-01-04 to 2016-01-04 inclusive which serves as the X-Axis and then the four value columns.  

HarrisMalik Established Member
Established Member

Re: Non-continuous line chart data

@ciarangreene 366 unique values for date cannnot fit in one frame and still readable. Power BI is intelligent enough to put a scroll bar underneath.

 

There are couple of options you can try:

 

1. Change the data type of date column to Date if it is text, Power BI will automatically rollup the dates labels to months but you can still see the values per day by hovering over the chart.

 

2. You can also use the custom visual "Advanced Time Slicer" and interactively scroll through your selected range.

 

Regards

 

Harris

itchyeyeballs Established Member
Established Member

Re: Non-continuous line chart data

Have you tried the advanced time slicer here - https://app.powerbi.com/visuals/

 

May solve the scale issues as you can dynamically select periods and the axis adjusts automatically. Not sure if it will give an issue with categorical side of things though.

 

Edit - sorry just realised this visual only seems to accomodate one data series so probably not suitable

ciarangreene Frequent Visitor
Frequent Visitor

Re: Non-continuous line chart data

@HarrisMalik,@itchyeyeballs; thanks for the help guys. The solution I think is to aggregate (weekly) and then to have the more detailed daily chart elsewhere so a user can drill into it. It's that or I could try to create a custom visual which handles my data set a bit better. This simple test has already taken a chunk of time more that I thought it would! 

 

Thanks again,

/C

Moderator WillT
Moderator

Re: Non-continuous line chart data

Hi everyone. At the moment, when you're using a continuous axis, Power BI always interpolates a straight line between points in the same series. We don't have an option to turn that off, but it's a good suggestion! Please post it on http://ideas.powerbi.com and we'll consider it for a future version!

 

Thanks

greggyb New Contributor
New Contributor

Re: Non-continuous line chart data

@ciarangreene Drilldown on line charts is coming soon from what I hear, so in the future you will be able to use weeks as the default label on the axis and then drill into individual day values all within a single chart.