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?
