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 have a table which is contain a date field, and i change it to "date only" on power query, and it shown correct under power query and slicer in PBI desktop.
however i create a table show customerno and lastest date, the it show the full date, see attached photo.
Is it possible to show the short date format on the table, just like the slicer and power query ?
Thanks in advance.
Joey
Solved! Go to Solution.
Select your Column Date and go to the Modeling tab. there is a data type there and format where you can change it.
Select your Column Date and go to the Modeling tab. there is a data type there and format where you can change it.
thank you so much./Joey
Hi @joeytsui
Use the below formula to create a calculated column.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |