Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, my client requested to create a chart that combine stacked and column chart together.
From my research, most of the solution only say "You can't"
https://community.powerbi.com/t5/Desktop/Clustered-stacked-column-chart/m-p/144714
also, there are custom visual from 3rd party company, which I can't use due to security reason
http://www.defteam.com/stacked-clustered-bar-chart/
I mean, Are there any workaround to get into that chart, i.,e. manipulating the data so the axis can be adjusted (there are tips in excel to manipulating the axis, but i am not sure how to do it in powerBI) ?
https://peltiertech.com/clustered-stacked-column-bar-charts/
thanks
Andre
Solved! Go to Solution.
Hi @andrehawari
Currently, It is not possible to create a Combination of Stacked and Column Chart, you can vote for this idea.
A workaround described in the fiist link would like below
Best Regards
Maggie
I have put together this solution that uses measures and is not depending on the data structure to be in just one table if it's still interesting.
https://www.villezekeviking.com/how-to-combine-a-clustered-and-stacked-chart-in-power-bi/
I followed this and my X axis are United States Forecast, United States Actual, United Kingdom Forecast, United Kingdom Actual - even with turning concat off. I cannot get Country on a seperate line.
Hi @andrehawari
You can do that in another way, create a hierarchy of Country=>Type and use that value in the x-axis, and use `Type->Cost` as the legend.
I think this would help you to get what you are looking for.
The below Image will give you more clarity.
you can vote for this idea.
HI Partik ,
i need to remove space beween forecast and actual bars and need space after country grouped bars ,it is possible ?
@PratikB Hi Pratik - Do you happen to have a sample pbix of this that you could share?
I followed this but when I drill through I get United States Forecast, United States Actual, United Kingdom Forecast, United Kingdom Actual. I don't get the Country on a seperate line for X axis; even with turning concat off.
Hi @andrehawari
Currently, It is not possible to create a Combination of Stacked and Column Chart, you can vote for this idea.
A workaround described in the fiist link would like below
Best Regards
Maggie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |