Forum Discussion
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 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,
9 Replies
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
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?
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
Good day dear, I am also trying to make a chart with table label in power bi, did you manage to solve?
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.
Has Microsoft solved this yet? I know there is a custom visual in the shop but it doesn't resize well/limited on formatting. It just seems wild that this is only available in excel.
