Forum Discussion
Anonymous
5 years agoNot applicable
How to create a line graph with grouped data.
I have data that looks similar to: How would I create a line graph that shows the heart rate by intensity for each first name, last name and gender group, as so:
- 5 years ago
To solve this problem, first off I would combine the names, as there doesn't seem to be any reason to split by surname or first name, you would always be splitting by full name, right? This can be done in PowerQuery - please ask if you're unsure.
Then, I would create a Line Chart visual, have intensity as the Axis, Heart Rate (as a Sum) as the Values, and then your new "Combined Name" field as your Legend.
I think this would give you the data you're trying to visualise. If gender after the name is critical, then you can combine the gender into the new name field.
VijayP
Community Champion
5 years agoAnonymous
Try using Small multiples in Line Chart
Anonymous
5 years agoNot applicable
That would create multiple graphs if I am correct and is not that which I am looking for.