powerbi - Power BI服务中的格式日期字段(Format date field in Power BI service)

Question

I have imported an Excel file to Power BI service from my OneDrive for Business.

(我已经从OneDrive for Business将Excel文件导入到Power BI服务。)

The file contains a simple Excel table and one of the fields is a date.

(该文件包含一个简单的Excel表，并且字段之一是日期。)

Now, in Power BI service, I get that field displayed as a whole number which isn't very useful to read in a report.

(现在，在Power BI服务中，我将该字段显示为一个整数，这对于读取报表不是很有用。)

How do I change the field to display as date?

(如何更改显示为日期的字段？)

Thanks!

(谢谢！)

  ask by Nuno Nogueira translate from so

Answer 1

This usually works by default for true Excel dates.

(默认情况下，这通常适用于真实的Excel日期。)

Anyway, just open the Edit Queries window and navigate to your table.

(无论如何，只要打开“编辑查询”窗口并导航到表。)

In the column header for your Date, change the Data type to Date.

(在日期列标题中，将数据类型更改为日期。)

Close & Apply to see the result in your report.

(关闭并应用以在报告中查看结果。)