Date field on X-axis is showing date/time 12am/12pm stamp, when date range is between 3 to 2 days

[Bhanuaripaka]

Hi all,  

I am facing an issue with date field on x-axis, when the date range is below 3 days(eg: 24/5 - 26/5) it is showing with time stamp am/pm.  I have tried changing  the datatype to Date and format to Short date but no luck.  

I want date field should be continous only. 

If date range is more than 3 days then its showing as Short date this is excatcly how i wanted for under 3-2 days date range.

Hope this explanintion make sense and appreciate your help. Thank you! 

[Uzi2019]

Hi @Bhanuaripaka 

If the no of days are less then it auto shows Am Pm in date it self.

Dont create anything just try to reduce the chart size or change the x axis setting to categorical

I hope I answered your question!

[Uzi2019]

Hi @Bhanuaripaka 

Try to change the date format to this under format setting then you can set to categorial.

see i have stretch the chart still it showing only month n day

i hope I answered your question!

[Bhanuaripaka]

Hi @fahadqadir3  ,thanks for your response. 

i want date field should be continous so that i can get date format like 24 May 2024 (dd/mmm/yyyy). If i choose Categorical i cant achevie that date format so Please let me know if i can achive above date format using Categorical. 

[fahadqadir3]

@Bhanuaripaka You need to create a new calculated Column and Format it as dd/mmm/yyyy

DateOnly = FORMAT('Table'[DATE_ID], "dd-mmm-yyyy")

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

[fahadqadir3]

@Bhanuaripaka Try to change the data type in Power Query and then on X-Axis select Type Categorical instead of Continuous.

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.