Forum Discussion

walshgarry1's avatar
walshgarry1
Frequent Visitor
6 years ago

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...
General Comment
Need Help
Tips and Tricks
v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi walshgarry1 ,

 

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

 

walshgarry1's avatar
walshgarry1
Frequent Visitor
6 years ago

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.