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
OobuJoobu
Frequent Visitor

Date displaying day of week in table when published, but not in pbix file

Hi,

 

I have a table in Power BI with one of the columns being a date field, showing in the format 01 August 2022. This is how it displays in the pbix file while I'm designing my report, and this is how I wish the date to be formatted.

 

01.PNG

 

I have removed the date hierarchy option.

 

When I publish the report and view it in a browser, all dates then also show the day of the week with the date formatting looking very different, e.g. Monday, August 01, 2022 

 

02.PNG

 

I don't wish to see the day of the week, and would like, when publshed, the date to show like it does in the pbix file (01 August 2022).

 

What have I done wrong/how could I achieve ths please?

 

Thanks

 

 

1 ACCEPTED SOLUTION
vanessafvg
Super User
Super User

if you click on the date in power bi   ie and then in the column tools formatting ribbon at the top what do you see?

 

vanessafvg_1-1658836618457.png

 

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
vanessafvg
Super User
Super User

if you click on the date in power bi   ie and then in the column tools formatting ribbon at the top what do you see?

 

vanessafvg_1-1658836618457.png

 

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Thanks, that's it! It was showing as "Long Date" so I changed it to the next option of "dd mmmm yyyy" and that's fixed it.

 

Thank you 🙂

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.