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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Plotting data with a date dd/mmm/yyyy hh:mm:ss AM PM every every 2 hours

Using DirectQuery, I'm trying to plot volume sold with a trend line of price every 2 hours. Unfortunately all the values for a particular day either get averaged or summed (no option for no summary).

 

Power BI Community, is there a way to plot the different hours or even minuites on the same day? Something in the ball park of whats below

 

*insert price trend line*

                                                                                                                          x

           x                                                                                                             x

           x                                       x                                                                    x

           x                                       x                                                                    x

June 1st 10:00 AM           June 1st  11:00 AM         ......................            June 2nd 10:00 AM

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Thanks @v-yulgu-msft,

I found that creating a custom Hierarchy out of a selection of custom bins did the trick 🙂

View solution in original post

2 REPLIES 2
v-yulgu-msft
Employee
Employee

Hi @Anonymous,

 

In your scenario, is the date column formatted as "dd/mmm/yyyy hh:mm:ss"? If so, when you directly add this column into axis section, don't select the "Date Hierarchy", by default, the axis will automatically divide datetime every 6 hours. The values won't be summed for a particular day.

1.PNG

 

As there existing some limitations for Direct Query mode, if the column in your table are date type without time part, I don't think we can divide it into datetime every 2 hours. The workaround is that you should modify the source table structure to mark it contain time values. In other words, the data records should be grouped every 2 hours for each day.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thanks @v-yulgu-msft,

I found that creating a custom Hierarchy out of a selection of custom bins did the trick 🙂

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.