Aggregate Hourly graph

[Anonymous]

Hi,

I've been trying to create the below graph in PowerBI:

It's a month's worth of data aggregated per time bracket.

My data column in BI has both date and time, however I can't just drill through like I'd hoped, and when I created a "Time Bracket" column using the following formula:  TIME BRACKET = MROUND(RP566[CREATE_DATE_TIME],"0:30") however when I create the graph using this as an axis, it keeps the data separated by date instead of aggregating it:

Any idea how I would achieve the above?

-Sam

[V-lianl-msft]

Hi @Anonymous ,

According to your description, you should format the year-month and time. Then take the time column as the X axis and the year-month column as the slicer.

Please try the DAX like this:

time = FORMAT(Sheet2[Start],"hh:mm:ss")

year_month = FORMAT(Sheet2[Start],"YYYY-MM")

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

To help you further I need pbix file. If possible please share a sample pbix file after removing sensitive information.Thanks.

My Recent Blog -

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[az38 · Accepted solution]

Hi @Anonymous 

it's difficult to help you without seeing full data model but try something like that

TIME BRACKET = MROUND(FORMAT(RP566[CREATE_DATE_TIME],"hh:mm:ss"),"0:30")

do not hesitate to give a kudo to useful posts and mark solutions as solution