Line visual with calendar dates field in x-axis does not show all days

[Fotis_flex]

Hallo,

I have a dataset with fields cal_date (every calendar day from 2025-01-01 to 2025-12-31), aircraftid and availability (Available or Unavailable).

I am trying to make a visual to display the number of aircraftids that are available and unavailable for all the calendar days of the year. I make a line chart (see screenshot) where x-axis is cal_date, value=aircraftid(Count) and then I also include color=availability to distinguish between available/unavailable aircrafts.

1. Why can’t I get to display all the calendar days in x-axis when I include the “availability” field in “color” option?? Notice that they start from June 15 instead of Jan 1!! This doesn’t make sense to me because when I remove this field from “color” I get all dates! But of course cannot distinguish between available/unavailable

2. It would be very nice to instead of just displaying the nr. of aircrafts available/unavailble to also show the actual values of the aircraftid’s that are available. Do you have a suggestion of what’s the best way to do this??

[msnehali]

Hello @Fotis_flex

Regarding your issue with limited dates when using “color” in Line Charts, it is due to a display limitation.

Line charts show up to 10,000 data points on the x-axis when no color field is selected. When color is populated, line charts show up to 400 data points on the x-axis and up to 25 data points for color.

see here:

Using line charts - Amazon QuickSight

A suggestion for showing the available aircraft ids, you can use actions - with Menu options, where your users can select if they want to see list of available aircrafts - and then it can take them to a new visual which will list all of it (navigation actions)

Something like this: