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.
Along with this it would be really nice to have a % change calculator. That way you could provide a set of data an calculate the % change.
I was able to make a measure that did percent change but it is difficult: Percent Change = CALCULATE(SUM('MyWebsite com'[Hits]),FILTER('MyWebsite com','MyWebsite com'[Date] >= MAX('MyWebsite com'[Date])-(COUNT('MyWebsite com'[Date])/2-1)))/CALCULATE(SUM('MyWebsite com'[Hits]),FILTER('MyWebsite com','MyWebsite com'[Date] < MAX('MyWebsite com'[Date])-(COUNT('MyWebsite com'[Date])/2-1)))-1
Where "MyWebsite" was a pull from google analytics and "hits" was the measure I was interested in calculating the % change on.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
the only reason I am not using Power BI in my company (although licensed worldwide) is that there is no automatic calculation embedded to POWER BI for Time intelligence: I have to create mobile reports where management need to see this montly variance vs budget, ytd variance vs budget, Rest of year to achieve budget, year over year growth....etc.
I have a rquirement where I need to display in multiple cards, countries performance, products performances, competitors performance. I have to create something like 20 tiles. filtering on mobile automatic time intelligence is a must. I really look forward when this features will be implemented.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
to be honest I do not have time to create month ,YTD,YOY metrics, Power BI should handle this automatically both in mobile/desktop versions.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
Same thing everyone else is saying - I am new to the software and thought I must be doing something wrong that I could not make this work.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
I have dates and I want the chart to summarize by month/year. Looks this basic task can not be done in the current version of PowerBI. Is that correct?
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
The lack of this basic time functionality is a show stopper for conversion of existing systems.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
Please add auto-date hierarchy for datetime and date datatypes! This is one of the major use cases for a BI platform that is end-user self service friendly.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
I'm amazed that after 2 years this still hasn't been resolved.
Without this functionality the product becomes significantly less useful to me.
When is this getting fixed? This is an urgent requirement with over 3,000 votes!
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
This is such a need, I shouldn't have to keep a separate .pbix with date tables/calculations to add to each new dataset/report.
RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.
Hi Will - very quiet on this subject. Multiple datasets to show Today, This Month is poor product management. Tableau makes this so simple !