Percentage Data Not Displaying Correctly in Line Graph

[amanda_wahlig]

I have a data set (comes from an external source) that contains survey data already summarized (so I can't just go to the base data and have BI do calculations):

Question	Year	% Positive	% Neutral	% Negative
Q1	2022	92.6	7.4	0
Q1	2023	93.0	7.0	0
Q2	2022	86.7	7.0	6.3
Q2	2023	85.7	8.9	7.5
Q3	2022	70.2	20.4	4.3
Q3	2023	75.3	17.6	7.0

The data in BI looks correct, and all the columns are marked as "don't summarize" with data type as "decimal number" and formatted as a percentage.

We have the same data for multiple years. I'm trying to create a line chart to show how the positive numbers to a given question have changed from year to year.

But when I create the line chart in BI, it only ever wants to show as some sort of calculation of the responses (count, sum, etc.) instead of just the values. Ideas? Thank you!

[amanda_wahlig · Accepted solution]

@v-yilong-msft 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.

[v-yilong-msft]

Hi @amanda_wahlig ,

I create a table as you mentioned.

I think you can add an index column in Power Query.

Then I put them into the line chart visual.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ahadkarimi]

Create a measure for each percentage column like this:
Positive Measure = AVERAGE('TableName'[% Positive])

[Ritaf1983]

Hi @amanda_wahlig 
Please refer to my detailed explanation in response to a similar post :
https://community.fabric.microsoft.com/t5/Desktop/Plot-Line-Chart-Industrial-Logging-without-Aggrega...

If previous post helped, then please consider Accepting it as the solution to help the other members find it more quickly