Dates format when using published live model

[srahman]

Hi I am working on a publish live model, but dates format does not reflect my system date format. 

Is there a way I can get dates in format dd-mmm-yyyy?

Is there any chnage you can do in the model so anyone useing the model have the dates in the same format independently to their region?

Is there a way to change the date for the specific view only?

In the model is there a way to change all date format insead of doing it individualy on every single field?

In one situation the date formt in the Column Fromat is showen correctly but the date is showen in the incorrect format in the report. Anyone knows why this can happen?

For date format taken from windows, does Power Bi takes only the default one? Noticed even if i change the system format the date in power bi keeps the default one, but it changes if I change the reagion.

Thanks

[Anonymous]

Hi @srahman ,
1. In Power BI, you can ensure that all users see the same date format by manually formatting each date column.
In the table view,  find Format and select `dd-mmm-yyyyy` as the custom format.
Once this is set up, all users using the model will see a consistent date format, unfortunately this has to be set manually on each relevant date column.

Power BI has no direct functionality to set a consistent format at the model level and apply it to all users regardless of their regional settings.
2. Unfortunately in Power BI it is not possible to individually change the date format for a specific view only. All date formats set are applied across all views that use that date column. If you need to use different date formats in different visual objects, you may need to create additional calculated columns or metrics to enable differently formatted date displays.
3. Unfortunately, Power BI does not provide the ability to change the format of all date fields in bulk. You will need to manually format each date column individually.
4. Incorrect date column display situations can be caused by the following reasons:
(1) The report's field settings may conflict with the column's formatting settings. You can view and adjust the report's region settings in `File > Options and Settings > Options > Region Settings.
(2) Some visual objects may have their own formatting settings, which override what you set in the column format. It is recommended that you check the formatting settings for each visual object to ensure that they do not conflict.
5. I think you are correct that Power BI typically uses the system's default zone settings for date formatting. If you only change the system's date format and do not change the region setting, Power BI may not automatically update the date format display. Changing the regional setting triggers Power BI to update the date format, in which case you can also change your date format to dd-mmmm-yy.

I hope my answer is helpful and I would be honoured if I can help you to solve your problem!
Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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