Percentages in a "Line and stacked column chart"

[kjartank]

I am trying to build a chart that has a line that shows me the average as a line (works fine) and then I want the columns to show the percentage of people that have answered "Agree", for the individual quarters. When I choose to show it as a percentage, it is the percentage for the grand total, instead of each individual quarter.

Here is what it looks like at a glance and the data I am using.

So how do I get the columns to show only the percentage that agree?

[v-qiuyu-msft · Accepted solution]

Hi @kjartank,

In your scenario, you can create a measure like below:

Per = DIVIDE(CALCULATE(SUM(Table1[Attitude 100]),FILTER(Table1,'Table1'[Attitude]="Agree")),CALCULATE(SUM('Table1'[Attitude 100]),FILTER(ALL(Table1),'Table1'[Quarter]=MAX('Table1'[Quarter]) )))

Best Regards,
Qiuyun Yu

[kjartank]

Thanks a lot @v-qiuyu-msft

That works just fine! I was wondering how I am supposed to work in a basic calculation. So the percentage of "Agree", minus the Percentage of "Disagree". There are three different kinds of values, namely Agree, Neither, Disagree. I want to have a "net agree" bar, that is the percentage of the agree answers, minus the disagree. Wich is basically the difference between the two of them.