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.
My dear all, previously there was a default date formatting of "mm/dd/yyyy" in the format selection but after I update my pbi desktop with the latest update. this date format was gone. I am using this date column in the column chart axis and dax formatting doesn't work in the column chart axis because it is being treated as text data type and I want to retain is as date to preserve the continuous type in the x-axis.
Can someone help me point on the right track? Thanks in advance!
Solved! Go to Solution.
Oh I got the answer myself😅 we can format the columns as well in the model view
@Dennis_Knows , Date format in power is usually taken from system format if not changed. Also as long as it showing a date it should work as the date on the axis. Are using axis type as continuous or categorical?
Can you share a sample pbix after removing sensitive data.
I did not saw any issue on date format at on Nov 2020 - https://community.powerbi.com/t5/Issues/idb-p/Issues
Hello, thank you! I am using continuous axis. I just got the answer on the model view. I posted in as well ^
Oh I got the answer myself😅 we can format the columns as well in the model view
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |