Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
YoanD
New Member

Power BI web wrong date format displayed

Hi, 

I work with the Web application of Power BI, and i get my datas from Streaming API.

In the json body, i have some String values and a Date Value.

When i create a report based on my streaming data (passed or failled test for each date for exemple ), the date is displayed with the wrong format.

 

 send that for exemple :

{
        "failed_test":  15,
        "passed_test":  92,
        "date":  "2023-05-17T12:32:39"
}
 
When it's displayed, i have 05-17-2023 12:32:39,
but what i want is a format dd-MM-yyyy hh:mm:ss  -> 17-05-2023 12:32:39
YoanD_0-1684326458173.png

Is there a solution on the web to format the date ?
I tried to set the language but it did nothing.

My location is in france for information, and it's set in the browser and Power BI to French.

 

Thanks a lot in advance for your help.

5 REPLIES 5
v-xinruzhu-msft
Community Support
Community Support

Hi @YoanD 

You can try to use format() function to set the format of the date in Power BI Desktop. 

e.g Measure = FORMAT(TODAY(),"dd-MM-yyyy hh:mm:ss")

You can also refer to the following link.

Solved: Date displayed in american format - Microsoft Power BI Community

Solved: Help to Change Date Format on Power Bi Service - Microsoft Power BI Community

 

Best Regards!

Yolo Zhu

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

 

 

 

 

Hi, 
Thanks for yor answer.
But like i said, i'm working a the Web version of power BI.

Is it possible to switch between the differente solution of PowerBi to modify date format ? 

And it seems i can't do anything on the desktop version with my streaming data : 

YoanD_0-1684482119919.png

All is lock 

Hi @YoanD 

Set the language of displaying Power BI to French, it can work

vxinruzhumsft_0-1684483060915.png

 

Select 'General'

vxinruzhumsft_1-1684483095933.png

 

Then set the language

vxinruzhumsft_2-1684483120840.png

 

and then refresh your report.

 

Best Regards!

Yolo Zhu

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

 

I already did those manipulation.
My language is set to browser language, and my browser language is set to french, but it doesn't works
I tried to set language to french in powerBi, and in my browser, too but it doesn't works.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors