Forum Discussion
Create a risk level vs contracts bar graph
Hi all,
I wanted to create a bar graph that represents the following:
| # of contracts | Risk Level |
Contract 1 | 5 |
| Contract 2 | 3 |
| Contract 3 | 3 |
| Contract 4 | 4 |
X-axis: 1, 2, 3, 4, 5 (these are the risk levels)
Y-axis: # of contracts (I have a field of about 10 contracts but they include the name of each contracts.
Summary: The table should show the amount of contracts per risk level.
Hope that made sense!
Hi Anonymous
In the Visualisation pane in PowerBI desktop I selected the stacked bar chart. Add the risk level column into the x-axis and then number of contracts column into the y-axis.
I also enabled data labels to display the total number on top of the bars.
3 Replies
- SeananSolution Supplier
Hi Anonymous
I've created a bar chart using dummy data to get the output you desire.
However, I'm a little bit confused as to what you are requesting help for? Do you mind explaining in a little more detail.
- AnonymousNot applicable
Hi, thank you for your response. That's actually what I'm looking for. Just an step-by-step explanation of how you did it.
Thank you
- SeananSolution Supplier
Hi Anonymous
In the Visualisation pane in PowerBI desktop I selected the stacked bar chart. Add the risk level column into the x-axis and then number of contracts column into the y-axis.
I also enabled data labels to display the total number on top of the bars.