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.
Is this available yet? Or can someone explain the work around to get Month-Year?
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
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.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
When implementing time intelligence - please think about to provide a basic fiscal year setting for those whose FY is not starting on January 1. Thanks.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
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.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
All,
I just watched the "Data Modeling for Power BI" presentation on YouTube from the "Data Insights Summit. The last 15 minutes are on current date functionality as well as some information about what's coming in the near future for date analysis.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
So excited to hear this is under development! Thanks to the Microsoft team for making our reporting easier!
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
I agree that this is a deal breaker. Without this we can't show basic insight that is necessary for our reports.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
All, If you need time intelligence features in reports, check out the DAX functions for this purpose. They are amazing and can do every metric I've seen requested through this thread. Or if you don't want to use DAX, create a Date Dimension in PowerQuery and use that for time intelligence.
Microsoft Team, I recommend you make some statement about your goals for this topic as I think this is costing you customers. People find this thread and say things like, "Tableau has time intelligence and PowerBI doesn't, I want Tableau." I realize this couldn't be farther from the truth but many others don't understand that the DAX functions provide more capability to match the needs of the report than any standardized (dumbed down) time intelligence features can.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
Agreed, it would be nice to not have to go through the workaround of creating a month-year field.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
absolutely critical to see data by date/time; show me my day in 10 sec, 30sec,1 min, 3 min, 5 min, 1 hrs, 4hrs, 1 day, 1 week intervals