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,
On my desktop app my date format for my date fields is:
'dd MONTH yyyy' for example: '09 January 2023'
but on the published report it changes date fields to a different format:
'DAY OF WEEK, MONTH dd, yyyy' for example: 'Monday, January 09, 2023'
I don't want this. Any ideas how I can fix this? Thanks!
One option is to create a calculated column in Power BI Desktop to format the date as desired, and then use this calculated column in the report instead of the original date column. Here's how:
=FORMAT([Date],"dd MONTH yyyy")
Note: If you have many date columns, you will need to create a calculated column for each one, or create a single calculated column that formats all of the date columns as desired.
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 |
---|---|
14 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |