Present UK Date Format in a page filter which uses a Live connection to an AtScale cube

[dosania]

Hi,

I have created a dashboard which is presenting the Date in a US format MM-DD-YYYY when I publish to the Service.

I would like this to be shown in the UK format, DD-MM-YYYY, which it correctly shows in the desktop version.

The web browser default is in a US format, and I'd rather not them need to change their default settings.

As the data is a live connection to an AtScale cube, changing the date format option in PowerBI is greyed out, as is the 'Regional Settings' in the File > Options > Current File > Report Settings > Regional Settings 

Settings' in the File > Options > Global Report Settings > Regional Settings  - Only shows English US

All date settings seem to be in an American Date format. Is there a way to change this to UK? Currently all options seem to be unavailable as using the Cube. 

Can anyone suggest how I might best fix this issue please?

[Ritaf1983 · Accepted solution]

As you publish the report, the dates change to the browser's format.
Unfortunately, dates can't be displayed in a different format than the browser's, so you have to change the browser settings.

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