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

[nishalit]

In the May release of Power BI Desktop we shipped a preview of the relative date slicer. To learn more check out this blog post: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/ In addition, the new Quick Measures feature has a bunch of time intelligence calculations that you can add to your model. Learn more about that feature here: https://powerbi.microsoft.com/en-us/blog/quick-measures-preview/

[fbcideas_migusr]

could not agree more 🙂 I think its time to end this constant need for date tables, even most power users don't get it... (ex: native pivot tables or see SmartCharts app for Excel, or our R/D addin for excel DataInsights ) https://store.office.com/smartcharts-for-excel-multi-user-site-license-WA104356536.aspx?assetid=WA104356536 http://rquintino.wordpress.com/2013/03/18/an-alternative-model-for-faster-excel-self-service-biexcel-data-insights-addon-part-i/

[virtuej]

Adding a date table is one great step forward. We should also automatically generate time intelligence fields to allow us to provide MTD, QTD, YoY, MoM, SDLW metrics. This would prevent most users from struggling with DAX to setup comparison reports. Based on POCs, this is one showstopper when comparing us to the competition.

[fbcideas_migusr]

I honestly cannot believe this is not already a feature. Anybody who is taking BI serious is comparing time periods versus each other. How else do you really notice deviations?

[brad_blanchard]

Our company is looking to switch from Tableau to Power BI; however, without the ability to easily report various metrics across different time elements we will not be able to make the switch. Having the functionality of selecting various dates/months/years and other time variables is critical.

[mg_stacey]

Also useful would to be able to define financial periods, e.g. A year starts in March. Performance point used to have this and it makes reporting yearly figures much easier in these scenarios

[xxcorpxx]

This is such top priority. I second Jason Virtue...We should also automatically generate time intelligence fields to allow us to provide MTD, QTD, YoY, MoM, SDLW metrics.

[kevin_toohey1]

As noted by all, this is a mandatory feature. Must be able to query/filter a dashboard's data display based on time/date periods. There should also be the ability to set a date time range for a dashboard's collection of charts/tables - date A to date B.

[dten]

During my test of PowerBI Designer, I found really difficult to create a slicer for Dates that was not related to a data source. I just needed it to filter the data shown on screen. It will be nice to have some kind of date control to globally filter the data.

[marcpalm]

This is really something that need to be on the top of the agenda in my view. Being able to have an easy way of selecting time periods as discussed below is kind of a base in Business Intelligence. I am really liking what I am seeing but I think these are one of the base functionalities that need to be in place. Kepp up the good work! BR Marc