topic Re: Going the Distance: Ranking Cruise Lines by Meters Traveled in Data Stories Gallery

Going the Distance: Ranking Cruise Lines by Meters Traveled

deldersveld — Wed, 26 Jul 2017 17:18:33 GMT

This visualization showcases a "Bump Chart" using Power BI, which displays ranking over time. While each cruise line has a different number of active ships and several varying routes, how do they rank relative to each other when it comes to the distance that each line logs each year?

eyJrIjoiOWY0ODlhMmYtODBhMi00MDcxLTllODMtYTZkZGU3NTlkNTY1IiwidCI6ImFjYzhhYWE1LWYxOTEtNDgyZi05MjFiLWNmNmMzM2E1ODgzMiIsImMiOjF9

Re: Going the Distance: Ranking Cruise Lines by Meters Traveled

RafalK — Tue, 01 Aug 2017 14:25:30 GMT

Nice! Is this a standard line chart visualization or some custom made one?

Regards

Re: Going the Distance: Ranking Cruise Lines by Meters Traveled

deldersveld — Tue, 01 Aug 2017 17:52:47 GMT

This uses the standard line chart with markers. You need to have the Axis be categorical to get the markers option. For the ranking, I used a measure similar to this one:

=RANKX(ALLSELECTED('Table'[Cruise Line]),CALCULATE(SUM('Table'[meters_traveled])))

Re: Going the Distance: Ranking Cruise Lines by Meters Traveled

AndyFQuinT — Fri, 01 Sep 2017 14:33:18 GMT

Great Dashboard,

Can you share the Pbix file please?

thanks,

Re: Going the Distance: Ranking Cruise Lines by Meters Traveled

ninalee — Tue, 23 Apr 2019 06:06:36 GMT

Great chart! Reminded me about my dream about world wide cruise.There are many decent cruises sites , I guess I will try services of Cruisedirect or may be Carnival.