Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create a risk level vs contracts bar graph

Hi all,

 

I wanted to create a bar graph that represents the following:

# of contractsRisk Level

Contract 1

5
Contract 23
Contract 33
Contract 44

 

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!

  • Seanan's avatar
    Seanan
    4 years ago

    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

  • Seanan's avatar
    Seanan
    Solution 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.

  • Anonymous's avatar
    Anonymous
    Not 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

    • Seanan's avatar
      Seanan
      Solution 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.