Analysis by date/time: View data by year, month, day, day of week, time of day, etc.

[riccardomuti]

If I have a date/time field in my data, I should be able to view metrics by year, by month, by day, by day of week, by time of day, and so on. I should be able to drill from month down to day, back up to month, and so on. I should also be able to ask for 'last 7 days' or '12 months ago' in my formulas, filters etc. I shouldn't need to create a "Date" table and all of these fields in my data. As long as I have a date/time field in my data, I should be able to do this analysis easily in the Power BI report (or Q&A).

[tanja_weber]

Hey, the relative date slicer is really cool. BUT it is not possible to change from "relative" to "between" (or other options) after the Slicer in the Report is published and viewed in PBI Web. Correct? Will that be implemented as well?

[pbiideas1]

This should not be closed yet. It's still not possible to easily filter data by month, week, day, etc as mentioned in this idea. The only part completed were the second sentence "I should also be able to ask for 'last 7 days' or '12 months ago' in my formulas, filters etc", the rest is still pending. It would be great if we had the possibility to select for example "filter by month", then have a dropdown list (or buttons) with all the months available in dataset. Or either give the possibility to block the interval of days between start date and end date in date slicer (ie: 7 days) so the user could simply move the interval shown forward and backward in time with just one click

[marcel_de_bever]

I would like to see the option for an interactive graph where we can visualise changes per time period. For example on the map, you can see volumes in locations growing or decreasing over time like in a movie.