Forum Discussion
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?
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.
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
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
