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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Syndicate_Admin
Administrator
Administrator

Array object, order of a custom column

Hello everyone,

I have a visual object where I place whole numbers (hours, no minutes) ranging from 0, 1, 2, 3...22, 23 (24 hours a day).

In a matrix I show what occurred each hour:

HourItem1Item2
010
1520
2 30
3 20
4 20
5 22
6515
716
81010
930
...
211010
22 10
23 10

But I want the order of the "Time" column to start from 6 (time that starts the shift tomorrow) and end at 5, it would be something like this:

HourItem1Item2
6
7
8
....
22
23
0
1
2
3
4
5

How can I make that poersonalized order since from the format of the visual object I can not do it (or can I?)

Thanks a lot

1 REPLY 1
Syndicate_Admin
Administrator
Administrator

It was easier than I thought...

I generated a conditional column and with the option "sort by column" I sort the time column according to a personalized numbering of the column I added

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors