How to create a line graph with grouped data.

[Anonymous]

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:

[pmay · Accepted solution]

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.

[Anonymous]

Am I correct that you are saying I should group the dat determining one of the lines into a new column and use that column as the legend?

Would I still be able to add a filter for just the first name, last name or gender, and would the visual still respond to that filter?

[pmay]

Yes.  Wasn't quite what I had in mind but that would also work, and even gives you more flexibility than what I suggested.

[VijayP]

@Anonymous 

Try using Small multiples in Line Chart 

[Anonymous]

That would create multiple graphs if I am correct and is not that which I am looking for.