Forum Discussion
100% stacked bar chart format
Thanks but no thanks....we know we can do that with stacked vertical charts. My question was specifically for the horizontal 100% charts which my client requires displaying as per my question.
Oh well its reassuring to know that at least that there are 2 of us whom cannot get the result i require.
BUt kind of sad that such a simple formatting option which in the depth of the native source code of Power BI i am sure would not be that difficult to activate....lets hope an MS Power BI program manger has just read that !!
I'll post it to the Ideas and see if anyone offers this some of their voting weight.
Cheers David
Hi DavidMoss,
I donot think it's make sense to display actual value on 100% stacked bar chart. Besacuse the Y-asix 100% stacked bar chart is Percentage. For example if you have the value below.
| Country | Legend | Value | Percentage |
| A | Apples | 10 | 20% |
| A | Bananas | 35 | 70% |
| A | Pears | 5 | 10% |
| B | Apples | 20 | 20% |
| B | Bananas | 70 | 70% |
| B | Pears | 10 | 10% |
As you can see, Apples value count 20% percentage in each country, but in country A is value is 10, and in country B is 20. If you dislay value on 100% stacked bar chart, then is should have different high. However they count same percentage in each country and they have the same high on 100% stacked bar chart.
Regards,
Charlie Liao