- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Bar Chart Question
Hi folks,
I'm running into issues displaying a % calculation for categories displayed in a bar chart. I need to figure a way to get a bar chart in POwer BI to show the categories in the y-axis, the x-axis needs to be capped at 100% and then the calculation needs to show the specific % for each category sorted by the highest % (its not cumulative so it doesnt need to be a grand total or a stacked 100% chart).
As an example, each category could be an exam and the % is the pass rate. How would I achieve that with the standard bar charts in Power BI? In my initial testing, simply putting the category column in the y-axis and the calculation in the x-axis results in each bar showing 100%.
Here's an example of what the calculation looks like in DAX:
Pass Rate = CALCULATE(COUNT('Table'[Student ID], 'Table'[Pass or Failed] = "Pass") / COUNT('Table'[Student ID])
Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Unfortunately, I am not able to hence why I am asking the question as generally as possible. Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @pbrenneise I understand your "issue" is just" a % calculation for categories ", so calculation. please provide some sample data and expected output per category
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-14-2024 08:08 PM | |||
01-06-2025 09:15 AM | |||
10-10-2024 11:54 AM | |||
08-26-2024 08:09 AM | |||
09-14-2024 07:09 AM |
User | Count |
---|---|
14 | |
14 | |
11 | |
10 | |
8 |