Bar chart with data table

[Bill_Go]

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 does not have capabilities to produce this particular chart.

I would really appreciate if someone could help with this as it is the only restriction forcing me using excel for data visualisation.

Many Thanks,

[Syndicate_Admin]

Good day dear, I am also trying to make a chart with table label in power bi, did you manage to solve?

[Bill_Go]

Hello,

Unfortunately, I have not been able to find a solution for this in Power BI, but have been using Excel power query & power pivot. 

[Bill_Go]

@Pragati11

Thank you for your quick response. I am aware of the chart you suggested but that doesn't give the desired results. 

[Pragati11]

HI @Bill_Go ,

In that case add more details to your question like sample data, etc. to give an understanding on why this doesn't work.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Pragati11]

Hi @Bill_Go,

There is a custom visual to get this similar visual in Power BI.

Link to the visual is here:

https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200000675?tab=overview

[Bill_Go]

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/2020	Product ID 1	Product D	1753
31/01/2020	Product ID 2	Product E	229
31/01/2020	Product ID 3	Product C	1458
31/01/2020	Product ID 4	Product B	222
31/01/2020	Product ID 5	Product D	174
31/01/2020	Product ID 6	Product A	1493
31/01/2020	Product ID 7	Product A	807
31/01/2020	Product ID 8	Product B	1126
31/01/2020	Product ID 9	Product B	1168
31/01/2020	Product ID 10	Product B	1577
31/01/2020	Product ID 11	Product B	415
31/01/2020	Product ID 12	Product B	971
31/01/2020	Product ID 13	Product B	234

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?

[v-rzhou-msft]

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]

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.