Format date in Mobile App in "Show as table"

[MikeMatveev]

Hi all, I've faced issue when I open chart in mobile application with option "Show As Table", it shows format with datetime and timezone, but in Power BI Desktop I have chosen needed format "MM/DD/YYYY" for this field.

Could you please help me, how to change this format? In power bi service is ok

[v-stephen-msft]

Hi @MikeMatveev ,

Based on my test, the date format displayed by ‘show as a table’ on Power BI mobile app is the same as yours.

If you want to display ‘MM/DD/YYYY’ format, you can use FORMAT function to modify the format of the date. But the field created is text format.

Column = FORMAT([Date],"MM/DD/YYYY")

Best Regards,

Stephen Tao

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

[MikeMatveev]

That would be text format, but I need a date. Field format is chosen as m/d/yyyy and web version (Power BI Service) shows that correctly and other visuals in mobile is ok, but "Show as table" shows as above in my example.

I will appreciate any ideas 

[v-stephen-msft]

Hi @MikeMatveev ,

Sorry for my late reply.

If it is a feature that is not currently available, you can create your idea and vote for it.

Website: https://ideas.powerbi.com/ideas/

Best Regards,

Stephen Tao

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