Forum Discussion

HEW's avatar
HEW
Helper III
8 years ago
Solved

Stacked bar chart with 2 values

Is it possible to create a stacked bar chart with 2 values? 

 

For example:

We have a requested leadtime and a confirmed leadtime. Both values are split into 3 groups:

- Early

- On day

- Late

I would every much like to have a stacked bar chart with the 2 leadtimes (requested and confirmed) as 2 bars and these 2 should be stacked so it is possible to see the split between the groups.

 

Thanks a lot in advance.

Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi HEW,

     

    I don't think there is an option to combine both Clustered and Stacked column chart together in Power BI currently. Here is the idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature. :smileyhappy:

     

    In addition, here is an article about how to combine bar graphs of stacked and unstacked columns in single chart in excel. Could you go to check if it help in your scenario?

     

    Regards

  • HEW's avatar
    HEW
    8 years ago

    Thanks a lot for your reply. I'll cross my fingers and hope it will be an option soon.

     

    Regards,

    Helen

2 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    Hi HEW,

     

    I don't think there is an option to combine both Clustered and Stacked column chart together in Power BI currently. Here is the idea shared on Power BI Ideas forum. You can vote it up and add your comments there to improve Power BI on this feature. :smileyhappy:

     

    In addition, here is an article about how to combine bar graphs of stacked and unstacked columns in single chart in excel. Could you go to check if it help in your scenario?

     

    Regards

    • HEW's avatar
      HEW
      Helper III
      8 years ago

      Thanks a lot for your reply. I'll cross my fingers and hope it will be an option soon.

       

      Regards,

      Helen