Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
@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
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |