Paginated Reports: Date fields change (format) when in either Power Bi Service or in excel

[akhaliq7]

When I finish with my paginated report the date fields are formatted as dd/mm/yyyy. But when i publish to power bi service it changes to d/mm/yyyy. Also when I export to excel it sometimes shows as numbers not sure why there is a inconsistency in what kind of format the date values will show in.

[akhaliq7]

yes thanks that worked.before i was using ToString and FormatDateTime functions but I would not recommend using these 2 functions as you then cannot sort or analyse by the date columns. As they become string/text columns. Another mistake I was making was clicking on clear -> clear format on excel this made my date fields become number fields avoid this and just manually change the row size to 15 and the column width to autofit.

[Hariharan_R · Accepted solution]

Hi,

Have you tried setting up the format explicitly using the textbox properties? 

Thanks

Hari