Date showing as datetime in Workspace:Report

[jcampbell474]

I have a desktop pbix with a date column that is formatted as date (only) m/d/yyyy.  It shows in that format everywhere in the desktop and main parts of it in PBI Service (Workspace:Report), but shows as m/d/yyyy hh:mm:ss AM/PM in the Decomposition tree. 

I can't find a place to change Decomposition tree formats.  Do date formats not apply to Decomposition trees?

Thanks!

[v-lid-msft · Accepted solution]

Hi @jcampbell474 ,

Thank you to point it, We have the same result as yours, we will report it and we will notice you if we got anything new. Currently we can create a calculated column to duplicate this column but format it as text as a workaround. 

DateText = FORMAT([Datetime],"m/d/yyyy")

Best regards,

[ctaylor]

@v-lid-msft is there a place that we in the community can report this bug?

[v-lid-msft]

Hi @jcampbell474 , @ctaylor ,

This is currently a limitation of the decomposition tree in preview. This will be fixed by the time the visual reaches general availability. Please try to use the workaround we have provided in this thread, sincerely apologize for any inconvenience this issue have caused.

Best regards,

[v-lid-msft]

Hi @ctaylor ,

For the issue in this thread, we have already reported, but we did not got confirm yet, if we have any news, we will update here.

If you have anther bug or issue, please try to post a new thread and we will try to reproduce it.

Best regards,