flight no display along with time

[fahmad]

Good morning all.

i have two fields flight_no and Flight_time.

Flight_Time         Flight_NO

00:00                   XY123

00:01                   XY124

00:05                   XY125

00:10                   XY126

00:20                   XY127

i want to show flight_no against flight time in graphical format in graph or as below

Regards,

Faraz Ahmad.

[amitchandak]

@fahmad , You need to create a 10 Min bucket

10 Min Bucket = time(hour([Flight_Time]), ROUNDUP(Minute([Flight_Time]),-1), 0)

Then create a rank

Rank = rankx(filter(Table, [10 Min Bucket] = earlier([10 Min Bucket])), [Flight_Time], ,asc,dense) 

Now put Rank on row, Bucket on column, and max of Flight_NO on values of matrix and try

[fahmad]

Thank you very much for quick reqply.

But some time i have more than once flight on same time example:

Flight Time  Flight_NO

 00:30        XY321

00:30         XY521

Regards.

Faraz Ahmad.

[V-lianl-msft · Accepted solution]

Hi @fahmad ,

The visual in power bi is almost the value after aggregation. If there are multiple values in the text, the first or last value will also be displayed. You can display several flights in the current time by CONCATENATEX function.

Column = CONCATENATEX(FILTER('Table',EARLIER('Table'[Flight Time])='Table'[Flight Time]),'Table'[Flight_no],",")

Measure = CONCATENATEX('Table','Table'[Flight_no],",")

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.