Forum Discussion

amanda_wahlig's avatar
amanda_wahlig
Frequent Visitor
2 years ago
Solved

Line Graphs with Percentages Data

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

 

OfficeYear% Positive
A202066.4%

A

2021

75.2%

A

2022

75.3%
A202367.5%
B202061.0%
B202162.5%
B202264.0%
B202367.7%
C202084.30%
C202188.00%
C202294.7%
C202392.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?

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

1 Reply

  • arava's avatar
    arava
    Regular Visitor

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