Trend for Grading

[Pinky0404]

Hi All,

I am trying to show a trend  for the grades. i have a column "Grade" which has grade values say A,B,C etc based on the rating score.

Eg:  Grade= if (rating<400,"F",if(rating>400  && if(rating <700,"D"),"C"). 

The below trend shows the grade values along with rating, and if i use the grade column under values dimension of the chart that is showing the count but not the Grades .Is it possible to just show the grades trend, Can someone help me on this?

Thanks in Advance!!

Pinky

[v-shex-msft]

Hi @Pinky0404,

I don't think you can apply trend feature on text value.

if you means analysis the trend of numeric value, you can turn on trend line to simply achieve your requirement.

Regards,

Xiaoxin Sheng