Forum Discussion

PERFEGG's avatar
PERFEGG
Frequent Visitor
4 years ago
Solved

Bump chart without timeline how?

I am trying to recreate the above bumpchart but failed, manage to get the rank, category but only end up with 1 set of dots

Need help how do i achieve a total 7 set point of line with the above example of a bump chart? (is that a visual settings?)

only manage to do 1 set =(

 

Thank you for your help & knowledge

  • got it, use rank dax with this 

    Spending Rank = RANKX(
    ALL(Sheet1[Generation]),Sheet1[SUM of Percentage])

4 Replies

  • Thank you, i have watched it, i am interested in the method too but i also cannot find the solution to that.

    • AnamPatel's avatar
      AnamPatel
      Resolver II

      There are other videos on the channel about the solution. The links are provided in that video.

       

      If I answered your question, mark my response as a Solution. Appreciate your KUDOS!

  • got it, use rank dax with this 

    Spending Rank = RANKX(
    ALL(Sheet1[Generation]),Sheet1[SUM of Percentage])