cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rourboat1
Frequent Visitor

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

Accepted Solutions
rourboat1
Frequent Visitor

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

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
Microsoft v-yulgu-msft
Microsoft

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

Hi @rourboat1,

 

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.
rourboat1
Frequent Visitor

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

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

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors