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.
Hi all,
I need help. I have input data from 1 August 2021 (1/8/2021) till 10 May 2022 (10/5/2022). However, Power BI has wrongly categorised some data to be in Mar 2021, decemember 2022, etc.
Appreciate any help. Thanks!!
Solved! Go to Solution.
Hi @Anonymous
You can try this, go to Power Query Editor, remove the step (see picture below). It is an automatic type change, you can also turn it off in options.
Then
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
You can try this, go to Power Query Editor, remove the step (see picture below). It is an automatic type change, you can also turn it off in options.
Then
result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
i.e the date for 3 december 2021 (3/12/2021) is taken by power bi as (12/3/2021) 12 March 2021
In Power BI Desktop, see if changing the regional settings fix the date format issue. But it only works a new report, not existing, so you may have to recreate your report ( try with just a simple data table first)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |