Not able to see the x value

[Anonymous]

Hello

I made a linear chart that shows the results of the last three months and that for each day. However, due to the number of days on the axis, we cannot see the date value correctly (see the attached picuture). Is there any way to solve that problem? In terms of chart width, I'm pretty close to the limit. I wonder if it might be possible to show the value on the X axis every 2 or 3 or 4 days. In terms of source, I'm already at 8.

Does anyone have a solution?

Best regards

[v-zhenbw-msft · Accepted solution]

Hi @Anonymous ,

Based on my test, if the column used in x-axis field is text type, we cannot change the x-axis from categorical to continuous.

Please check the data type of your date column and change it to date type or date/time type, then we should able to change the type of x-axis.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I have make some verifications and you were right, the field was in text format.  I have change it to date m-dd.  Now, the x axis is in month and year.  Can we set it at least at week and year ex:2020-w1, 2020-w2 and so on or any scale below the month.

Regards.

[Greg_Deckler]

So is your x-axis continuous or categorical? Generally continuous tries to be smart about what to display.

[Anonymous]

I have tried to put it on continuous but it alway switch back to categorical

Could you propose something to solve this issue?

Regards,