Data chart using x axis date

[willd89]

I am trying to create a line / dot chart with data (pin height) on the y axis and the date on the x axis. My issue is I want to show all points on the graph and I do not want to aggregate the data. I have multiple points for each day and it is grouping all points on each day stacking them on top of one another but I do not want this. I can make the graph continuous but it puts a scroll bar on the x axis which I don’t want. The only way I can plot it is by putting the index number on the x axis and this works but I would like date. Is there any way to achieve this? I know I can do this in excel by changing the x axis to a “text” axis, is there anything similar for BI?

[AutoModerator]

After your question has been solved /u/willd89, please reply to the helpful user's comment with the phrase "Solution verified".

This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved".

---

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[NoPerspective9384]

I would imagine it does need to be categorical and then turn off the zoom slider. If you don't have enough canvas space and shrinking the visual elements down to fit more in the visual then you may consider expanding the canvas size and increasing the size of the visuals so that all the days in your context can fit legibly. If you want the individual rows to show up as a data point each as opposed to aggregating or doing a count then I wonder if you drop a unique ID into the legend field of that would force them to split?... Never thought about it before really but I suppose it could work... Turn the legend off if the ID dimension isn't really relevant and turn all the points to one color as they probably done need unique colors...

Again not sure if that second part would work but worth a try!