Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |