Forum Discussion
Percentage Data Not Displaying Correctly in Line Graph
Anonymous was the closest to the solution. I didn't need to add an index column - just use the "sum" of the percentage column and scale the y-axis from 0 to 1. It's still not entirely clear to me why BI would make it look like you're adding anything, but it works.
I realized that the question wasn't clear: I wanted a line chart with the percentage on the y-axis, the year on the x-axis, and then three lines to show the values in each year that were positive, neutral, and negative. A slicer would allow users to view the results for a given question.
Anonymous was the closest to the solution. I didn't need to add an index column - just use the "sum" of the percentage column and scale the y-axis from 0 to 1. It's still not entirely clear to me why BI would make it look like you're adding anything, but it works.
I realized that the question wasn't clear: I wanted a line chart with the percentage on the y-axis, the year on the x-axis, and then three lines to show the values in each year that were positive, neutral, and negative. A slicer would allow users to view the results for a given question.