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