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
Frixel
Post Prodigy
Post Prodigy

How delete name of the day

Hi all,

 

How can i convert the dat so i don`t see the name of the day?

 

1.jpg

2 ACCEPTED SOLUTIONS
FarhanAhmed
Community Champion
Community Champion

Click on date and go to column tools to change the format of date accordingly

 

DateFormat.png







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




View solution in original post

@Frixel,

 

Awesome !!!

 

No, that shouldn't be much of an issue 🙂

 

Can you give a thumbs up and select above comment of mine as the solution !!!

 

View solution in original post

26 REPLIES 26

I think you need to change the Windows Region Settings.

 

- Go to Region Setting

- Click on region

- Click on change "Data Formats"

Change Data FormatChange Data Format

 

- Select Short Date Type as "YYYY-MM-DD"

- Once you change the format in region settings I think you need to re-open your PBI file. Once you it opened go to Formatting of date and Click "*" in dateformat and you will get your results.

Short DateShort Date

 

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




@FarhanAhmed 

 

It is standing as English but i can`t  change "Data Format" as in your example.

1.jpg

Operating Systems Region Settings (Windows), not of Power BI.

 

 







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




@FarhanAhmed 

This is how it stands by me, mus i changed that?

 

1.jpg

At Below you see "change data formats". Click on that

ChangeRegionSettings.png

 

Once you click on this you will see screen like this

 

RegionalSettings-shortdate.png







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




@Anand24 

 

1.jpg

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.