Improve date and time hierarchy and add day of week, week of year number and time with hour of day, minute and seconds.
We need the hierarchy to be able to determine time from a date and time table and allow for visuals to drill up and down to day of week, week of year, hour of day, minutes ect. Also to allow for a filter to be added to this field where the last nth hours shoudl be displayed based on hour of day and not necessarily total count or sum for the hours. Many users might not be familiar with measures or DAX, so making this existing functionality withing the visualizations panel would help a lot for insightful analysis.
1
vote
Cornel
shared this idea