topic Re: Scroller Visual Question in Developer

Scroller Visual Question

Black3y — Tue, 03 Mar 2020 14:20:24 GMT

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

Re: Scroller Visual Question

Pragati11 — Wed, 04 Mar 2020 14:37:16 GMT

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

Re: Scroller Visual Question

Black3y — Wed, 04 Mar 2020 15:31:15 GMT

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

Re: Scroller Visual Question

Pragati11 — Wed, 04 Mar 2020 15:49:26 GMT

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

Re: Scroller Visual Question

Black3y — Wed, 04 Mar 2020 15:57:06 GMT

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!

Re: Scroller Visual Question

Pragati11 — Wed, 04 Mar 2020 16:00:55 GMT

Hi @Black3y ,

Is it possible to share pbix file?

Thanks,

Pragati

Re: Scroller Visual Question

Black3y — Wed, 04 Mar 2020 16:04:27 GMT

@Pragati11

It looks to me as if the visual is actually putting the graphis in as I can swithc it on / off in the settings and the arrows disapaer, so I guess it just hasn't been programmed to handle 0...

Unless I can modify a visual then I guess I am stuck!

Re: Scroller Visual Question

Pragati11 — Wed, 04 Mar 2020 16:06:07 GMT

Hi @Black3y ,

Looks like I will need your pbix file to check further. CAn you share it?

Thanks,

Pragati

Re: Scroller Visual Question

Black3y — Wed, 04 Mar 2020 16:12:22 GMT

@Pragati11 sure see attached... please excuse the content though, I am new to PowerBI!

PowerBI File

Re: Scroller Visual Question

Pragati11 — Wed, 04 Mar 2020 16:48:42 GMT

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