Auto group axis

[Anonymous]

Hi sir, 

I'm not good in English so I apology for any hard understand message.

Let's say I have a measure of "profit percentage" in every hour   and when I plot it with "date & time"  It will be like

But when I expand the time span with date slicer,  It's going to be mess. 

So the question is , Can the axis auto group such as group from hr to day, day to week , week to month depends on the time we change. 

Or can create new measure that will be the average 1 day, 5day,10day ... depend on the slicer 

The main goal is to the make that line more easily to look. 

my data is like this 

Thank you in advance 

Regards,

Max

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may try using Drill down in a visualization in Power BI.