Forum Discussion
Real Time Dashboard data comparison
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
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?
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.
