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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors