Forum Discussion
Percentage Data Not Displaying Correctly in Line Graph
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!
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.
4 Replies
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-Aggregation/m-p/3535513#M1166354If previous post helped, then please consider Accepting it as the solution to help the other members find it more quickly
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.
Create a measure for each percentage column like this:
Positive Measure = AVERAGE('TableName'[% Positive])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.
