Going the Distance: Ranking Cruise Lines by Meters Traveled 08-01-2017 10:52 AM

[deldersveld]

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

[ninalee]

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.

[AndyFQuinT]

Great Dashboard,

Can you share the Pbix file please?

thanks,

[RafalK]

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

Regards

[deldersveld]

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])))