Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

2 values in Power BI when creating a stacked graph

I am trying to create something similar to the below in Power BI, where I can show the difference between 'Received vs Completed' in a stacked Bar Chart. 

However I would appreciate any other ideas on how to show 'Received v Completed' within Power BI.

 

Thank You

  • Hi Anonymous 

     

    I’m not sure if you’d like to show the difference like below:

    1. Drag the [Status] to X-axis along with [Month], then use drill down, Rec VS Com in specific month shown correspondingly.

    2. If you’d like to show total Rev VS total Com, drag [Status] on top, the visual shows as the first, then use drill down, get the second one.

    Best regards,

    Dina Ye

2 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous 

     

    I’m not sure if you’d like to show the difference like below:

    1. Drag the [Status] to X-axis along with [Month], then use drill down, Rec VS Com in specific month shown correspondingly.

    2. If you’d like to show total Rev VS total Com, drag [Status] on top, the visual shows as the first, then use drill down, get the second one.

    Best regards,

    Dina Ye

    • v-diye-msft's avatar
      v-diye-msft
      Icon for Community Support rankCommunity Support

      Hi Anonymous 

       

      If my above post helps, could you please consider Accept it as the solution to help the other members find it more quickly. thanks!

       

      Best regards,

      Dina Ye