Skip to main content

Power BI

Completed

Analysis by date/time: View data by year, month, day, day of week, time of day, etc.

Vote (2101) Share
Riccardo Muti's profile image

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)
Riccardo Muti's profile image Profile Picture

Power BI User on 05 Jul 2020 22:33:29

RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.

This is very important for the average user. If Power BI could offer a filter that gives the user the option to filter by latest date, and last 3 months, next 3 months etc. this would mean that we would choose Power BI over other BI tools.
Tableau offers so much more within the in built filters at present.

Riccardo Muti's profile image Profile Picture

GAGAN KUMAR PATRA on 05 Jul 2020 22:33:27

RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.

its a long time from when it started..is there any planned ETA

Riccardo Muti's profile image Profile Picture

Scott A on 05 Jul 2020 22:33:00

RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.

I would like to be able to do a date calculation--such as "< NOW-24HOURS"--on a column.

Riccardo Muti's profile image Profile Picture

Power BI User on 05 Jul 2020 22:32:39

RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.

Expand the (period) Over (period), (period) To Date, Previous (period) beyond Year, Quarter, and Month to include Semester, Week, & Day. Also ability to set Start Day of Week

Riccardo Muti's profile image Profile Picture

Kofi Ebakyea on 05 Jul 2020 22:30:48

RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.

have data set for each day and will like to know how to prepare the data so that I can have it by week, month, quarter and year so that I can visualize that and drill down on it. Any help?

Riccardo Muti's profile image Profile Picture

Power BI User on 05 Jul 2020 22:30:32

RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.

Any update on this?

Riccardo Muti's profile image Profile Picture

Ryan Denton on 05 Jul 2020 22:29:29

RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.

Another +1

Riccardo Muti's profile image Profile Picture

Power BI User on 05 Jul 2020 22:29:27

RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.

'+1

Riccardo Muti's profile image Profile Picture

Power BI User on 05 Jul 2020 22:26:31

RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.

Hi Power BI team, has there been any update on this feature? when are we going to be able to filter date like in any given website (from/to)? this is a fundamental feature for non-technical users making use of the dashboards. Thanks

Riccardo Muti's profile image Profile Picture

Jeff Daniel on 05 Jul 2020 22:25:14

RE: Analysis by date/time: View data by year, month, day, day of week, time of day, etc.

Dates in general are fairly difficult enough to deal with. But not having this basic feature of filter "This Month", "Last Month", "This Year", "Last year", Last 7 days, last x days and so on. Really breaks the simplicity of handling dates. From a business point, this is truly putting a road block in getting Powerbi launched, since all our reports are based on date filters like these. In Microsoft Dynamics you have endless date options when making advanced find views, but PowerBi needs to catch up. Such a work around to try and get the same charts to carry over into this new platform.

Love everything PowerBi is doing. They by far, role out more updates then any of the other Microsoft products do and are doing there best to implement user feedback. Something Microsoft rarely does, but this PowerBi team is strongly focused on. Keep up the good work.