Date Format in Power Bi

Hi Bush 

I can't reproduce your problem.  If you select your date column you can choose to display the dates as dd/mm/yyyy

You can also type in the format you want into the Format box (rather than choose a format from the drop down list).

So if you type in dd/mm/yyyy and hit enter the dates should also be displayed the way you want.

If you supply your PBIX file I can see what's going on.

Phil

I tried but its not working at all..Basically the format dax function is not working in my power rbi Report..Only while changing the system Region settings I can get thee required data format.Can't do it for each Report.

First 3 columns are due to change in System Region Settings..Last column I tried using dax ..Its not working

Hi Bush 

You don't do this type of formatting the way you are trying to do it.  

I also think you are misunderstanding the idea of display format and the way actual underlying data is shown to you on screen by PBI.

For example, with this data in my table

Once loaded into PBI, I can select that column and in the Format area, type in dd/mm/yyyy and I get this shown in a table visual

You don't need to use the FORMAT function to simply display data in a particular format.  

Using a format string as I've done here, the underlying data is not changed - you can see in the image above that the Data type still says it is Date/time.

Download this PBIX file to see my example

Maybe this article on custom formats will help 

Custom Formatting Strings in Power BI

regards

Phil