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.
I would like to tag on a secondary issue to the date/time issue. When applying a filter to a report to isolate data from just one month, say last month, I have to repin that report to my dashboard every time I update the filter for the latest month. Any way that I can change my month filter without needing to repin?
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
Does the new custom visualization satisfy this some?
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
This is the biggest problem in Power BI. There are no decent date filters/views. I would like to have: View per week? / View per month? / A Timeline slicer (like in Excel) /..
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
Really need this feature!
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
struggling to create reports without this. this is required asap
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
Seems like a no brainer, are we any closer?
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
Wow I usually never comment on these types of things but I agree that this would be a very useful feature! Great job so far with Power BI
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
Just adding it to the conversation here... Excel 2016 has some cool Time grouping enhancements... please bring them over to Power BI! https://blogs.office.com/2015/10/13/time-grouping-enhancements-in-excel-2016/
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
Adding capabilities to easily filter by relative dates would be nice (think Tableau, Qlik, Sisense, etc). A time filter should give the ability to easily filter for past N days/weeks/months.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
You were considering this almost a year ago. Its quite an important missing feature. Is it anywhere near being implemented yet?