how to change date format to dd/mm/yyyy in power bi

You can change date formatting in Power BI at a few different levels, depending on whether you want it to apply to a single visual, a whole field, or the report globally.

Method 1: Format a date column (Power Query / Data view)

1. Go to the Data view (or Power Query Editor via Transform Data).
2. Click on the date column.
3. In Power Query Editor, right-click the column header → Change Type → Using Locale. Choose Date type and a locale like "English (United Kingdom)" which uses dd/mm/yyyy, then close and apply.
4. Alternatively, in the main Data view, select the column, go to the Column tools ribbon, and under Formatting, choose a date format from the dropdown (or select "More date/time formats" and pick/customize dd/mm/yyyy).

Method 2: Custom format via Column tools

1. Select the date field in the Fields pane or Data view.
2. In the Column tools ribbon, click the Format dropdown.
3. Choose Custom and type dd/mm/yyyy in the format code box, then press Enter.

Method 3: Change it for a specific visual

1. Click on the visual containing the date field.
2. Go to the Format your visual pane (paint roller icon).
3. Find the axis or field formatting section for the date, and set the display units/format there if the option is available (this varies by visual type).

Method 4: Change the report's regional/locale settings

1. Go to File → Options and settings → Options.
2. Under Current File → Regional Settings, change the locale to one that defaults to dd/mm/yyyy (e.g., United Kingdom), which affects default date formatting throughout the report.

Using DAX (if you need a text version) Create a calculated column: FORMAT([DateColumn], "dd/mm/yyyy"). Note this converts the date to text, so it won't sort correctly as a date and loses date-specific features like drill-down hierarchies — use it only for display purposes, such as in a table or card visual.

Note: Power BI Desktop's date formatting is influenced by your Windows regional settings too, so results can sometimes vary depending on your machine's locale unless you explicitly set a custom format.