Different date format on same report

[TristanO216]

Hello,

I am facing an issue quite embarassing: I have two different visual, using different data sources, except for the X-axis, which is based on a Date table I built using DAX for both of them. On Power BI desktop, eveything works fine, but on Power BI service, the two visual uses two different formats for dates. The visual on the right is a consolidation of the visual on the left, usign data from multiple tables, as the one on the lest only uses 1 table + the date table.

Below a picture to understand better my issue.

I do not understand at all what is going on here, as everything is set u using european format for dates (dd/mm/yyyy), and my browser and OS uses this format for dates.

Can you please enlight me?

Thank you for your help,

Tristan

[TristanO216 · Accepted solution]

Hi all,

Thank to all of you for your support.

I still don't know what happened, but the issue solved itself by simply deleting the report and the dataset from Services and publishing it again. Publishing without deleting it did not correct the issue before.

I even tried to recreate my issue, but I could'nt. This is very strange, but anyway now it is solved.

Once again, thank you for your support, 

Regards,

Tristan

[ibarrau]

Hi. This is quite interesting. Let me explain you what I know and hope you found it. Power Bi Desktop and Service can run formats (dates, numbers, etc) in a different way. Power Bi Service will follow the language configured in your browser to render those formats. On the other hand Power Bi Desktop is trickier because it contains on the settings some configurations for the "Region". It's not only about your OS, there are region settings on the tool.

It's really strange but it depends on the configurations, for example: I have Power Bi Desktop installed in english but with Argentinian Region in an Spanish OS that shows dates and numbers in Argentinian format. Language and Region is not the same, those can set the difference. Then my browser is in english showing in Service US format.

Hope you can find in this configurations your answer.

Regards,

[TristanO216]

Hi ibarrau,

First of all, thanks for your quick answer.

Then, I fully understand your point. However, as mentioned in my post, all languages and date formats are set to european (OS, browser and OS region). I also thought it could be the source of my issue, so I checked it first, and checked that there was no difference between the way Desktop and Service could analyze the data.

The main issue here is that two visual on the same report, using the same data, are not interpreting it the same way!

Thank you for your help,

Tristan

[Anonymous]

HI @TristanO216,

>>Then, I fully understand your point. However, as mentioned in my post, all languages and date formats are set to european (OS, browser and OS region).

So you mean you changes the browser language? In fact, the power is service has language settings in the power bi settings, the general visual/tile header formats are based on it. Modify the web browser language not change on power bi service data formats.

In addition, system regions setting only change the current display format. This style not save or kept when you use this report power bi service or other devices.

Regards,

Xiaoxin Sheng

[TristanO216]

Hi @Anonymous,
 
Thank you for your answer.
I set the Power BI service language to Default Browser first, with the browser in UK english (like my OS and OS region, even if it does not have an impact). The issue was present.
Then, I changed Power BI service language to French to see if it could have an impact, and the issue was still there.
 
Maybe I am not clear enough, so please find below two screenshot : one from Desktop and the other one from Services.
They use exactly the same data, but are not interpreting the date the same way. I do not understand how is that possible.

 
PBI Desktop (what I want)

PBI Services (what I have)
 
Thank you for your support.
 
Tristan

---

[Anonymous]

Hi @TristanO216,

Can you please share a pbix file with some dummy data to test? It is hard to reproduce your issue without any sample data. 

Notice: please not attach sensitive data in your sample.
Regards,

Xiaoxin Sheng