Trending Grades and showing actual values

[Jvo]

I have test data to express what I am trying to do below.

I need to show grade changes for multiple users over the year in a trending visual. Using an area/Line chart only allows to aggregate and I am trying to show the actual column value "Grade" in the hover over/ drill down.

Name	Test ID	Date	Grade
John	2122	1/1/2019	A
John	2171	4/5/2019	A
John	2133	5/2/2019	C
Joe	2231	1/5/2019	D
Joe	2543	4/10/2019	C
Joe	2345	5/2/2019	C
Tim	2666	1/1/2019	B
Tim	2343	4/5/2019	C
Tim	2311	5/2/2019	A
Sammy	2765	1/1/2019	B
Sammy	2476	4/5/2019	C
Sammy	2222	5/2/2019	C

[v-shex-msft · Accepted solution]

HI @Jvo ,

Nope, current line/area chart does not support analysis text fields without aggregation mode. I'd like to suggest you add a calculated column to convert grade to number to analysis on area/line chart.

Grade Tranfromed = UNICODE([Grade])

Regards,

Xiaoxin Sheng