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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.