Creating a basic 100% stacked bar chart

[kimchizal]

I thought it would be easy, but I'm having some trouble creating a 100% stacked bar chart.

My simplified dataset is at a granularity like the following. It represents a response's score for a question:

Question Name | Score

question1                 3

question1                 2

question2                 1

question2                 2

question2                 3

question2                 4

Where the range of score is 1-4.  I was hoping to make this 100% stacked bar chart organized by question, and shows the count of responses per given score. So in my sample data set, question2's bar chart would show 4 bars each at 25% since there are 4 responses, all with a different score. And Question1 would be a split of 50% to Score=3 and 50% to score=2

I've put the Question field in the Axis, and score as the legend, but the legend is showing a distinct legend for each single record in the table like this:

It's also not grouping all the same scores together. The question that has the 33% splits has all scores of 2, so it should be just 100% of 1 color/score.

[v-shex-msft]

Hi @kimchizal,

According to your snapshot, your graph seems summarize on 'count' mode, please double check your table structure to confirm score column is configured as numeric type.

Regards,

Xiaoxin Sheng

[kimchizal]

Yep, the value is 'Count of Score' and I've confirmed that it's a numeric data type, specifically whole number.

Any other ideas as to what's going on?

[HotChilli]

Please attach a picture of the right hand side of the report when the 100% stacked bar chart is selected. We need to see the fields.

[HotChilli]

What have you got in the 'Value' section? It should be Count of Score.