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.
Hello everyone,
I need to create Input date time field example "14/11/2020 11:15:54"
so that I can get the start data time for a report.
I want to be able to type it in ? or something close
Any ideas ?
Eric
Hi @ericet ,
I think you may want to find the exact date from the slicer to filter. You can try to use Advanced filtering from Filters.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Maybe the date serial number could be the solution ?
How do I find the serial number of a date ?
Eric
@ericet - If I am understanding your point, you want to change the data type of the date column
Change the format of the date column to Date/Time
Appreciate your kudos!! Mark my post as solution if this helps.
No that's not what I mean.
I need the user to be able to Input date time field example "14/11/2020 11:15:54"
Is it posiblle to have a slicer that includes date time ?
Eric
Possible workaround is-
Two tables for Hour and two tables for Minute. I would suggest creating two time table instead. Please refer to the snapshot below.
startTimeTable = GENERATESERIES ( TIME ( 0, 0, 0 ), TIME ( 23, 59, 0 ), TIME ( 0, 1, 0 ) )
Make sure the date format should be MM/DD/YYYY HH:MM:SS
Appreciate your kudos!! Mark my post as solution if it helps.
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 |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |