Forum Discussion

muehtob's avatar
muehtob
Frequent Visitor
8 years ago

Time Axis Sorting Start at different time

Hello ,   for Shift analysis i need to display a whole day Strating at 22:00 the day before and ends at 21:59 the same day with Power BI. My problem is , that if i use a Time Datatype for the Axis...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI muehtob,

 

 

I'd like to suggest you to add column to store custom sort order, then use this column as sort by column of time column.

Sort by column in Power BI Desktop

 

Regards,

Xiaoxin Sheng

muehtob's avatar
muehtob
Frequent Visitor
8 years ago

Hey Anonymous as you can see in the first picture , if i select the Time [time datatype] as the axis the option for sort by disappears. I already added another column for sorting but i can only select it if i choose the time [as a string] for the axis (second picture).  And if i choose that option the graph is to "long" and not compressable (auto group as it is possibe if you select time [time datatype] as an axis)

 

i know it sounds a little bit confusing but i hope someone can understand my problem and help

 

Regards,

Tobi

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi muehtob,

     

    Nope. I test with some methods but can't modify sort order of chart axis label, maybe you can try to submit an idea for this requirement.

     

    Regards,

    Xiaoxin Sheng