Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
I want the same like this with percentage:
Thank you very much in advance.
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.
Hey Maggi, it helped me a lot, thanks!!!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |