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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

Top Solution Authors