How to format dates to US format of MM/DD/YYYY in Power BI

[MillyF]

Hi Team,

I formatted dates in Power Query to US format of MM/DD/YYYY but when I create  a simple table in Dashboard, the date format is either DD/MM/YYYY or date is broken down into columns (Year, Quarter, Month, Day). Is there a way to format date in Report (or do I go back to Power Query to edit dates?)

[Fowmy · Accepted solution]

@MillyF 

Your date is broken down into columns (Year, Quarter, Month, Day) as Power BI creates a dates hierarchy, you can tuen it off under Options > Current File, Data Load, uncheck Auto date/time. You can create a dates table in your model for better modeling .

If you need to format your dates column to a desired format, select the dates column, and choose a format or directly type the format you need

[MillyF]

Thank you very much! This worked!