Real Time Dashboard data comparison

[walshgarry1]

Hello Community I'm hoping someone can help me.

I have designed a dashboard that uses a streaming dataset (JSON) and shows metric data for an individual. I can show real time current speed over time on a line graph along with some other metrics. The dashboard works well but what i would like to do is add a second players data to the JSON string and do a comparisson between the two.

This is where i get stuck. Each player has an individual device ID and i'm not sure how to add more than one ID to the dashboard.

Below is a picture of the working dashboard for one player and the JSON output from power bi.

Here are the two JSON rows and ID's I want to feed in realtime and compare.

{"Id":"0555","TDist":4656.7812,"CurSp":0.17777792,"Impacts":34,"Sprints":21,"T":"2020-03-07T17:57:36.3"}
{"Id":"8a92","TDist":4136.4614,"CurSp":0.013888899,"Impacts":16,"Sprints":7,"T":"2020-03-07T17:57:36.3"}

Can someone please help? I'm really hoping this can be done.

[az38]

@walshgarry1  hi

how do you want to visualize it on card visual? it should be average or max or what in [Total Distance] card for example?

to add second line to chart add [Id] field as legend

[walshgarry1]

Ideally i would like to show a current speed over tme for two players on the same line chart.

I would also like to My issue is how do I add a second ID to my dataset?

My JSON string has individual ID's for each player but when I create my power bi dataset json code i don't know how to define new cards for the second player. 

I really want to see on the same dashboard cards for each player: 

Player 1 - Current Speed, Total Distance, Impacts, Sprints

Player 2 - Current Speed, Total Distance, Impacts, Sprints

Then a line chart showing current speed over time for both players id's something like this:

Do you think this is possible?

[v-frfei-msft]

Hi @walshgarry1 ,

Please create a line chart like that to work on it.

[walshgarry1]

Hello and than you for the feedback.

By modifying the code that is sending the JSON data to Power Bi I have managed to succesfully add a second players ID and current speed to the line graph shown below. This has solved my first issue.

The next issue I have is that I am not able to define the individual cards for the second player.

As you can see from the diagram I have added cards for a second player 2 but they are just coming up add duplicates of player 1.

The two players ID's and data are being pushed to power bi every second but they are defined as the same value TDist, CurSp, Impacts & Sprints. Is there a way I can define these values by ID in the Power Bi dataset???

This is the format of the JSON string I am sending.

{"Id":"0555","TDist":4656.7812,"CurSp":0.17777792,"Impacts":34,"Sprints":21,"T":"2020-03-07T17:57:36.3"}
{"Id":"8a92","TDist":4136.4614,"CurSp":0.013888899,"Impacts":16,"Sprints":7,"T":"2020-03-07T17:57:36.3"}

The dataset is currently configured below:

Any help on this would be greatly appreciated.