I’m attempting to do something in Power BI Desktop that I’ve been able to do in SSRS but I can’t seem to figure it out.
I work in the Aviation industry and so, for a given flight, I would like to have a column in my report table for crew. This column, per flight, would display the pilot’s name and the co-pilot’s name below that.
Presently, I can do this:
FlightNumber PilotName CoPilotName
ABC123 John Doe Fred Smith
What I’d like to do:
ABC123 John Doe
I’m either missing something basic in using Power BI Desktop or, perhaps, I need to be using Power BI Report Builder in order to accomplish this…
Any and all advice will be greatly appreciated. Thanks!