Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
How to change the format from 2020-02-11T08:45:58.6470000 to 2020-02-11 in power bi, it returns wrong date and month if i'm using the format function
Solved! Go to Solution.
Hi @Anonymous ,
On the query editor be sure that you have the format of the columns as Date/Time then go to add column and select the Date Only, this will give you a new column with only the date part should work as expected.
then delete the initial column
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
On the query editor be sure that you have the format of the columns as Date/Time then go to add column and select the Date Only, this will give you a new column with only the date part should work as expected.
then delete the initial column
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank you
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 51 | |
| 42 | |
| 34 | |
| 33 | |
| 21 |
| User | Count |
|---|---|
| 143 | |
| 125 | |
| 100 | |
| 80 | |
| 61 |