Forum Discussion
100% stacked bar chart format
Hello David,
That isn't possible yet. Why you don't use the Stacked bar chart.
Turn on the data labels and you will get were you are looking for.
Hope that will help for you!
Kind Regards,
Jorre
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
In fact showing the value makes a lot of sense because it allows another measure to be described within a single chart... a 100% stacked chart should allow you to quickly sense changes in composition (for example, sales by product line) over whatever is the X axis, but as you already said, it tells you nothing about the volume (or importance of those changes)
As it is now you could easily see that - let's say - Fruit sales went from 25% to 50% from Jan to Feb but... was that because you sold more Fruits? or because you sold less of the other products? is it truly relevant because in Feb you sell the same or a lot more than in Jan? or it is neglible because that particular Feb you almost did no sale at all?
See all those question could be answered with a 100% stacked chart that *also* allowed you to display a value but can't be answered as it is now
Makes sense?
