Power BI
CompletedAnalysis by date/time: View data by year, month, day, day of week, time of day, etc.
Riccardo Muti on 13 Nov 2014 09:53:55
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).
Administrator on 11 May 2017 06:45:53
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/
- Comments (112)
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
This feature is a must. How can I offer a customer a time-dimension, when I can not slice it properly?
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
A bit of a nightmare to use right now because of lack of this feature.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
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.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
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.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
Clearly needed feature to sort by time periods. Normal way of presenting data.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
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
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
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.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
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
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
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.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
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?