Hour of the Day with a date lead 30/12/1899

[ElliotP]

Evening,

After the new update to powerbi, I've loaded up my report to find my Hour of the Day time table column now has a leading date "30/12/1899" before it. This hurts the aesthetic of the visual and I'm not sure how to remove it.

I've searched the forum and checked that the column type in both Query Editor as well as just the desktop view is set to "Time" with the format "h:mm tt".

Thoughts or ideas?

[v-ljerr-msft]

Hi @ElliotP,

I just the verified that the Time Type works all fine without this issue with the latest version of Power BI Desktop(2.49.4831.521 64-bit (August 2017)) on my environment.

What's your data source? Could you post some sample data which can help us reproduce this issue? It's better that you can also share a sample pbix file which can reproduce the issue. So that we can help further investigate on it. 

Regards

[ElliotP]

Thanks for the quick respone @v-ljerr-msft

My data source is an Azure SQL table. The issue is enimating from my "time" table.'

Here is a picture of the issue: https://gyazo.com/2d7368e87b4c82cb341b641824cb490c

Here is a link to a sample pbix: https://1drv.ms/u/s!At8Q-ZbRnAj8hwaG6v7KLrdhe4jo

[MarcelBeug]

Somehow the field is formatted with a date instead of only time. If you adjust that, it should be fine.

"Bestand" is Dutch for "File".

[ElliotP]

@MarcelBeugThat isn't present in my file when I look, thoughts?

[v-ljerr-msft]

Hi @ElliotP,

A little weird! I got the same result as @MarcelBeug's when I opened your shared pbix file. After I changed the format to "h:mm tt", it worked well without any issue. Here is the modified pbix for your reference. 

As we cannot reproduce this issue, I would suggest you create a support ticket on Power BI Support page for better assistance if the issue persists. 

Regards

[MarcelBeug]

Hm, actually my thoughts are: "if I take the effort to take a screenshot and include that in my post, why don't you do the same?"