Forum Discussion
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.
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
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
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
- 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.
greggyb; thanks, I'll keep an eye out for these.
