Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to 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.
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
85 | |
84 | |
73 | |
49 |
User | Count |
---|---|
142 | |
133 | |
110 | |
68 | |
55 |