- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Report Builder ( paginated report ) remove time from date field
Hello,
In report builder, I have a datetime field which currently shows as: dd/mm/yyyy hh:mm:ss
How do I remove the time section and have the field only show the date - dd/mm/yyyy
Thank you
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I found the answer
FORMAT ( [datetime field], 'dd/mm/yyyy') as Date
I wasn't putting the as Date (or whatever else I want to call that field) part, but once I added that it worked fine.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I found the answer
FORMAT ( [datetime field], 'dd/mm/yyyy') as Date
I wasn't putting the as Date (or whatever else I want to call that field) part, but once I added that it worked fine.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Ry5,
I am dealing with the exact same issue, where do you put this formula? In a calculated field or in Query Designer?
TIA
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Gkk!
I know this is late but hopefully it helps someone out there.
You can accomplish this by going into the field value itself. Right-click on the value within the visual you are attempting to format, and select 'Placeholder Properties'. There you can navigate to 'Number', where you can format the number and date, and select the formatting type you'd like for that value.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Subject | Author | Posted | |
---|---|---|---|
03-21-2024 12:51 AM | |||
02-19-2024 11:42 AM | |||
06-17-2024 09:57 AM | |||
08-16-2024 03:05 PM | |||
08-01-2024 12:49 AM |
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 |