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.
- ciarangreene10 years agoAdvocate II
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.
- HarrisMalik10 years agoContinued Contributor
ciarangreene The scroll bar normally appears when you have too many members on an axis. Can you share a screenshot?
- ciarangreene10 years agoAdvocate II
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.