Problem with date display in a visual

[willpage]

Hello.

I have a report with a date table. The date column is set to data type: Date with the format as d/mm/yy.

I use the column in a visual to show the change in a value over time, so the date is the X axis.

Despite being a date column, the visual shows time (12a.m.)

Here is the settings of the date columm:

This is what it looks like in table view:

Despite that, the axis of any charts that use this column show an annoying and superfluous time stamp:

How can I fix this?

TIA.

[v-yetao1-msft · Accepted solution]

Hi @willpage ，

I think I find the reason .

In Visualizations pane ,you can change the Type of X axis .Choose Categorical instead of Continuous. The time (12a.m.) may not display. The visual I used is Line Chart visual .

Best Regards

Community Support Team _ Ailsa Tao

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

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[willpage]

The report contains sensitive employment data. Is there an alternative to sharing it publically?