Forum Discussion

dickovan's avatar
dickovan
Regular Visitor
9 years ago
Solved

quarter hour

This is my first Power BI project. Have a datetime field and want to have the x-axis be by quarter hour. I created a new column and, using nested if statements, reformatted the time to be at 15 minut...
  • hugoberry's avatar
    hugoberry
    9 years ago

    As mentioned by  parry2k you are on the right track, just over engineering your sorting.

    Sot by the original date time field and make sure that the data type is date time.

hugoberry's avatar
hugoberry
Icon for Responsive Resident rankResponsive Resident
9 years ago

As mentioned by  parry2k you are on the right track, just over engineering your sorting.

Sot by the original date time field and make sure that the data type is date time.

dickovan's avatar
dickovan
Regular Visitor
9 years ago

After noodling on this, given all of your input, I realized that the x-axis sequence was based on an alpha sort of the underlying time column (10, 11, 12, 1:, 2:, ...7:,  ) with the last column, 10:00, being based on times between 9:45:01 and 9:59:59.

 

So Power BI knew the column was time (it had formatted the times that I passed it from 2:15 to 2:15:00 PM) it was treating the values as alpha for the x-axis. I reformatted the column to TIME and all was well.

 

Thank you all for your ideas.