Forum Discussion

TristanO216's avatar
TristanO216
Frequent Visitor
5 years ago
Solved

Different date format on same report

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....
Need Help
Tips and Tricks
  • TristanO216's avatar
    TristanO216
    5 years ago

    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

TristanO216's avatar
TristanO216
Frequent Visitor
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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