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.
Wow as a new user of this software, trying to get up to speed, this is a major disappointment - this seems like such basic functionality that I would expect from the start! How could this have been deprioritized?!
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
Agree - Power BI's date and time formatting is actually less flexible and slower than Excel 2007... agree with Brad Wilcox below, it's a real pain point in data processing that doesn't exist in your competitors
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
I totally agree, the date options are not very useful now. Time is probably the most important metric in reguard to slicing and dicing the data for a company trying to compare one year to the last, etc etc...
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
Under review for so long, is there any update on this?
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
Would alos like the option to determin the first day of the week, at the moment in Q&A if you use a excel source (so that "yesterday" etc work the question "sales for this week" results include sunday.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
I found a way to calculate % change dynamically by using a date table to select a specified date range. The Measure is quite complex. (Percent Change = CALCULATE(SUM('Data'[Hits]),FILTER('Data','Data'[Date] >= MAX('Data'[Date])-(COUNT('Data'[Date])/2-1)))/CALCULATE(SUM('Data'[Hits]),FILTER('Data','Data'[Date] < MAX('Data'[Date])-(COUNT('Data'[Date])/2-1)))-1
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
Would love this as well.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
This is one of the biggest road blocks I face trying to bring users from Tableau to Power BI. Date filtering is so simple and easy there compared to Power BI. Help me out please.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
its such a drag not being able to do a simple date/time filtering/grouping... need this up and running asap!
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
I'm completely shocked this wasn't a feature out of the gate. Also with no estimated timeline, I can't continue to recommend this application for my org, so thanks?