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 stay...
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

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

      • Black3y's avatar
        Black3y
        Microsoft Employee
        6 years ago

        Hi Pragati11 

         

        Sorry, that was a bit of a typo.  See below conditional formatting on the table that is working...

         

        The Slider visual doesnt come with any controls over formatting so I can only assume it's pulling the data it sees from these fields inclusive of formatting, but doesnt seem to like 0!