Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Aggregate Hourly graph

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 jus...
Need Help
  • az38's avatar
    az38
    6 years ago

    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

     

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago
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.