Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
rax99
Helper V
Helper V

How to drill on datetime data without aggregating into level above

I have some data with a DateTime column. What I need to be able to do is drill down to the second level. I've created my own hierarchy Year>month>day>hours>minutes>seconds.

 

The only problem is if I plot some data on a line chart, and I drill down to the day, hours, minutes or seconds level, the data is grouped by the whole amount.

 

For example, if I drill down to the Day7 level, it will give me the data for all Day7's across all months. Or if I drill down to hour4, it will aggregate across every hour4, across every day of every month of every year.

 

so this sample data has 2 days worth of data.

 

Below shows across 2 days:

 

rax99_0-1641400769409.png

If I drill down a level, it gives me the hours:

 

rax99_1-1641401019661.png

 

But as you can see the hours have been aggregated across both days. 

 

I wanted to see the trend across the 2 days, so expect the chart to look something like the following:

 

rax99_2-1641401227845.png

 

Apologies for the crude illustration, but how can something like this be achieved?

1 ACCEPTED SOLUTION
rax99
Helper V
Helper V

Managed to solve it. If anyone is interested, the data type for the day/month/hour/min/sec columns I changed to Text. This stopped the data grouping into the number buckets

View solution in original post

1 REPLY 1
rax99
Helper V
Helper V

Managed to solve it. If anyone is interested, the data type for the day/month/hour/min/sec columns I changed to Text. This stopped the data grouping into the number buckets

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.