Problem with X-axis dates granularity

[mohamed_camara]

Hello,

I have a linear graph with two curves with daily granularity. However, in the X-axis of the graphical representation, the date is indeed displayed in daily format dd/mmm/yyyy but only the start dates of the month are represented.

I changed the orientation of the dates of the X-axis to vertical position as advised in some discussions but that doesn’t change anything. Could you help me find the solution please?

[Wakana]

hi @mohamed_camara

Welcome to Quick Sight Community!

it appears to me that the X-axis configured with monthly granularity in visual setting.

[mohamed_camara]

hello Wakana, thank you for your response.

precisely, the X axis is configured with daily granularity in this
graph (see screenshot) which is what is surprising. 

I saw in some threads that the problem could be due to the 
fact that there  are a lot of values ​​in the date labels 
and that in this case the horizontal orientation of the 
X axis labels takes up too much space.
So I took care to set the orientation of the labels to 'vertical'
but that doesn't change anything.

[robert.eibers]

Hey @mohamed_camara ,

Maybe you could provide some sample data. I can’t recreate the problem. Another issue I could imagine is if the date format within the dataset is recognized as MM/dd/yyyy; maybe that could also be the problem.

BR
Robert

[mohamed_camara]

Hi Robert, the date column is called ‘chargeperioddate’:

I said dd/MM/yyy because it is the french display of MM/dd/yyyy

[robert.eibers]

And do your two value fields also have missing data for those dates? If there are nulls, they wouldn’t be shown in the graph.

[mohamed_camara]

@robert.eibers

nd do your two value fields also have missing data for those dates? If there are nulls, they wouldn’t be shown in the graph.

Hello Robert, I checked carefully and my two value fields do not 
contain any empty or null values

[WLS-Luis]

Hi @mohamed_camara,

Hope this message finds you well! Just wanted to check in since this thread hasn’t received a response in a while. Were you able to find a workaround regarding your question or are you still facing persistent issues? If we do not hear back in 3 business days, I’ll close out of this topic.

Thanks!

[WLS-Luis]

Hi @mohamed_camara,

Since we have not heard back, I’m going to close out this topic. However, if you have any other questions, please feel free to create a new post in the community and link this discussion for respective information if needed.

Thank you!