Create a risk level vs contracts bar graph

[Anonymous]

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!

[Anonymous]

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

[Seanan · Accepted solution]

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.

[Seanan]

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.