Forum Discussion

Bill_Go's avatar
Bill_Go
Frequent Visitor
4 years ago

Bar chart with data table

Can someone please let me know if there is a way to replicate the below chart in power BI? The only available chart with data table in power BI is the "Line and stacked column chart with table", but ...
Bill_Go's avatar
Bill_Go
Frequent Visitor
4 years ago

Hello,

Apologies for the late response. 

The Line and stacked column chart - does not allow to add years as table headers on the data table. it automatically converts them into calculated stats (sum/count). 

The data I am using to create the chart in excel is of the format:

DateProduct IDProduct NameSales (USD)

31/01/2020Product ID 1Product D1753
31/01/2020Product ID 2Product E229
31/01/2020Product ID 3Product C1458
31/01/2020Product ID 4Product B222
31/01/2020Product ID 5Product D174
31/01/2020Product ID 6Product A1493
31/01/2020Product ID 7Product A807
31/01/2020Product ID 8Product B1126
31/01/2020Product ID 9Product B1168
31/01/2020Product ID 10Product B1577
31/01/2020Product ID 11Product B415
31/01/2020Product ID 12Product B971
31/01/2020Product ID 13Product B234

 

I need to create the same chart on Power BI as the one in excel. I am not sure why this chart type is available in excel but not PBI?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Bill_Go ,

     

    As far as I know, there is not an existing visual/a customer visual with function to show clustered column chart and table visual at the same time.

    I think you can create a clustered column chart and a table visual, then group thems.

    Or you can right click your clustered column chart and use "Show as a table" function.

    Result is as below.

    Or you can to create your own custom visual at Charticulator or charts.powerbi.tips.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Bill_Go's avatar
      Bill_Go
      Frequent Visitor
      4 years ago

      Thank you for your feedback. I was hoping to get it as one visual as have applied few filters to update chart based on products. I will stick with excel pivot charts and slicers in this case.
      I am a bit disappointed that have to use both excel and Power BI for the same project.