Grouped bar chart with y-axis in percent

[Anonymous]

Hi guys,

I have a questionary based on 10 questions with 3 possible answers: "Satisfied", "As expected" and "Unsatisfied". If i add this 3 categories to a bar chart looks fine, but the real problem is when i want to see the percentage. In PWB the unique option is "show as percentage of total". I came from IBM Cognos and exists another one option like "Show as percentage of category".

So, anyone knows how can I do to show percentage of by category and year? is only possible doing by manually in a table?

I have this:

https://imgur.com/fS91yLH

I want the same like this with percentage:

https://imgur.com/v5CgCWW

Thank you very much in advance.

[v-juanli-msft]

Hi @Anonymous

Does my reply help you?

If not, please let me know.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Oscar_Mtz_V]

Hey Maggi, it helped me a lot, thanks!!!

[v-juanli-msft]

Hi @Anonymous

Does this measure work as expected?

per_by_year =
CALCULATE (
    COUNT ( Sheet1[question] ),
    ALLEXCEPT ( Sheet1, Sheet1[year], Sheet1[answer] )
)
    / CALCULATE ( COUNT ( Sheet1[question] ), ALLEXCEPT ( Sheet1, Sheet1[year] ) )

Best Regards

Maggie