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
PDeGaris
New Member

Date format issues

Hi,

I have a date formatting issue - BI is recognising a date (Dec-2022) as both Dec-2022 and Dec- 2023?  P & L matrix is showing Dec-2022 in a filtered visual for both FY 2022 and FY 2023.  AC values showing when filtered for FY 2023 and no PY value, so BI seems to recognize the date correctly but when filtered for FY 2024, Dec 2022 is displayed incorrectly but with the correct PY values and no AC value - so BI seems to be recognizing as Dec-2023? The date is showing correctly in the data table and does not appear to be duplicated.  The data is coming from an excel spreadsheet built with power query from a monthly data dump into a spreadsheet in which the date seems to be correct also.

Thanks in advance

 

Screen Shot 2023-12-10 at 7.46.25 am.pngScreen Shot 2023-12-10 at 7.46.59 am.pngScreen Shot 2023-12-10 at 7.46.12 am.png

1 ACCEPTED SOLUTION

Thanks HotChilli,

 

I seem to have solved the issue just now - the date our financial software exports as the month is the 12/23/22 (mm/dd/yy) (seems the 23rd is an odd day to pick but that's another issue) - for some reason any spreadsheets with a 2022 year date, BI was reading the year as 23.  Changing the date format in the original excel files to dd/mm/yyyy fixed the problem.

Thanks Anyway.

View solution in original post

2 REPLIES 2
HotChilli
Super User
Super User

There's not enough detail in the question to help you.  Can you provide the pbix please?

Thanks HotChilli,

 

I seem to have solved the issue just now - the date our financial software exports as the month is the 12/23/22 (mm/dd/yy) (seems the 23rd is an odd day to pick but that's another issue) - for some reason any spreadsheets with a 2022 year date, BI was reading the year as 23.  Changing the date format in the original excel files to dd/mm/yyyy fixed the problem.

Thanks Anyway.

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.

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.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.