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).

[dprotsyk]

Was very confused this week before I realized that the currently available 'automatic time hierarchies' are not available in direct connection mode. This is rather unfortunate, as we do quite a few of those when prototyping.

[GeorgeR]

This has been solved introducing a simple date table into the model. That is to list the FY, CY, Q, week, month, etc for every given date value thus it can be referred to create Y/Y Q/Q etc calculations, reports.

[alexh2]

Is this available yet? Or can someone explain the work around to get Month-Year?

[Jefferson_sd12]

Dates in general are fairly difficult enough to deal with. But not having this basic feature of filter "This Month", "Last Month", "This Year", "Last year", Last 7 days, last x days and so on. Really breaks the simplicity of handling dates. From a business point, this is truly putting a road block in getting Powerbi launched, since all our reports are based on date filters like these. In Microsoft Dynamics you have endless date options when making advanced find views, but PowerBi needs to catch up. Such a work around to try and get the same charts to carry over into this new platform. Love everything PowerBi is doing. They by far, role out more updates then any of the other Microsoft products do and are doing there best to implement user feedback. Something Microsoft rarely does, but this PowerBi team is strongly focused on. Keep up the good work.

[alvarjcrack]

Hi Power BI team, has there been any update on this feature? when are we going to be able to filter date like in any given website (from/to)? this is a fundamental feature for non-technical users making use of the dashboards. Thanks

[ryan_denton]

Another +1

[rehansaeed1]

'+1

[kebakyea]

have data set for each day and will like to know how to prepare the data so that I can have it by week, month, quarter and year so that I can visualize that and drill down on it. Any help?

[dstramilov1]

Any update on this?

[v-drobb]

Expand the (period) Over (period), (period) To Date, Previous (period) beyond Year, Quarter, and Month to include Semester, Week, & Day. Also ability to set Start Day of Week