Forum Discussion

Black3y's avatar
Black3y
Microsoft Employee
6 years ago
Solved

Scroller Visual Question

Hi all,

 

I am using the scroller visual as it works very well with a scoreboard feature I am doing. Below is how the data shows in the leaderboard, with people's rank either going up, down or staying the same... with either an up arrow, down arrow or dash to indicate said movement.

 

 

However, the slider seems to show people who dont move as an up arrow, as below (see Erik for example).

 

Any help on this visual appreciated...

 

Thanks,

 

Mark

Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi Black3y ,

     

    After digging into few things online, it looks like this visual supports a deviation which is either Positive or Negative. 0 seems to be positive to me. Therefore it's showing it that way in Scroller visual.

     

    I will try to dig more and update if I find something new.

     

    If this helps appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

9 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Black3y ,

     

    CAn you please post your calculation for Up, Down, Same symbols here? Looks like this is a condition issue in your calculation.

     

    Thanks,

    Pragati

    • Black3y's avatar
      Black3y
      Microsoft Employee
      6 years ago

      Hi Pragati11 

       

      I am using a quick measure as below, to rum the difference between ranks from one day to another.

       

      RankDiff2 = sum(Leaderboard1[Rank]) - SUM(Leaderboard2[Rank])
       
      On the leaderboard that is working I then use conditional formatting to modify "rankdiff" to Green / Up arrow if more than 1, Yellow if 0 or Red and Down Arrow if less than 0.
       
      I am guessing the scroller I am using works differently to this...?
      • Pragati11's avatar
        Pragati11
        Super User
        6 years ago

        Hi Black3y ,

         

        As per your comment:

        On the leaderboard that is working I then use conditional formatting to modify "rankdiff" to Green / Up arrow if more than 1, Yellow if 0 or Red and Down Arrow if less than 0.

         

        Don't you think the highlighted part above should be > than 0 for GREEN/UP ARROW rather than > 1?

         

        If this helps appreciate a Kudos and mark it as a Solution! 🙂

         

        Thanks,

        Pragati