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