Time unexpectedly appearing next to date labels in bar chart

[vpatel55]

I have a horizontal bar chart with dates on the axis. However for some odd reason, hours are apperaing next to the date, such as "18 Mar 00:00", "18 Mar 06:00", etc. There should be no time at all, only dates. As a result, the chart appears untidy with lots of gaps:

This is peculiar, as the data contains no DateTime data at all, only dates. Also, they are formatted as dates in Power Query, and it is formatted as Date only in the modelling tab, according to the dd/MM/yyyy format. There are no date groups or hierachies.

As help to remove the redundant hours would be appreciated.

Thank you.

[vivran22]

Hello @vpatel55 

Can you share the sample data file/pbix file?

Cheers!
Vivek

https://www.vivran.in/
Connect on LinkedIn

[vpatel55 · Accepted solution]

@vivran22 in the course of trying to redact all the sensitive information and send you a new PBIX, I found that the new file that I created didn't have the issue. I then found the issue, it is that when I turned off the hierachy, for some odd reason, it inserts hours into the date. But if you keep the hierachy, are drill-down to date level, then it is fine! Kudos to you anyway!