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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.