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

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 i can't sort anymore.

 PowerBi_1.PNGPowerBi_2.PNG

And if i use the time as text i can sort but bars are to broad , and i have to scroll to see the whole day.

I need kind of a combination of the two.

Can anyone suggest any solution ?

 

best regards

Tobi

3 REPLIES 3
Community Support Team
Community Support Team

Re: Time Axis Sorting Start at different time

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
muehtob Frequent Visitor
Frequent Visitor

Re: Time Axis Sorting Start at different time

Hey @v-shex-msft 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

Community Support Team
Community Support Team

Re: Time Axis Sorting Start at different time

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 203 members 2,637 guests
Please welcome our newest community members: