Support for Hour and Minute for Drill Down Behavior of Date

[Alkhos]

Hi,

I was wondering if there is any way to emulate support for drilling down a date field to levels lower than day.

I can see that in PBI desktop, currently, a date/time field is already broken into Year,Quarter,Month,Day and I can drill down to these levels to see various aggregations of my visuals.

What I was wondering is that if my date/time is in the formst YYYY/MM/DD HH:MM then is there any way to also drill down to HH and MM levels for the plotted data? If it is not supported out of the box, is there a way to emulate this behavior?

Thanks

Ali

[Greg_Deckler · Accepted solution]

You should be able to build your own custom hierarchy. Basically, create custom columns for Year, Month, Day, Hour and Minute and then drag and drop them into a hierarchy.

[Seth_C_Bauer]

@Alkhos You could create calculate columns against the date field and drop that into the axis under the year/mo/day fields.

They would look something like

Hour = TIMEVALUE(Table[datetime_field])

Minute = MINUTE(Table[datetime_field])

Set Axis values as

Year

Quarter

Month

Day

Hour

Minute