Line Graphs with Percentages Data

[amanda_wahlig]

I have data that looks like this (the data comes already summarized, I can't just use raw data and compute in BI):

Office	Year	% Positive
A	2020	66.4%
A	2021	75.2%
A	2022	75.3%
A	2023	67.5%
B	2020	61.0%
B	2021	62.5%
B	2022	64.0%
B	2023	67.7%
C	2020	84.30%
C	2021	88.00%
C	2022	94.7%
C	2023	92.9%

I'm trying to create a line chart with year on the X axis, percent on the Y axis, and then different lines to show each of the three offices' results over time. But the problem is that the only way that I can get BI to have the percentage on the Y axis is to use "sum", which means if multiple offices are selected, it just adds up the numbers (instead of creating separate trend lines for each office).

Any advice on how to, in this example, have a line for each office on the same visual?

[arava · Accepted solution]

Is 'YourTable'[Office] in the Legend field for the visual?