Forum Discussion
How to show percentage Count Rows on Stacked Bar Chart
Hi,
I have been using power bi for a short time. I hope you can help me. I have the following table:
| Sales Order | Sales Amount |
| 1 | 5200 |
| 2 | 3100 |
| 3 | 1400 |
| 4 | 2800 |
| 5 | 4500 |
| 6 | 1200 |
| 7 | 1800 |
| 8 | 1550 |
| 9 | 500 |
| 10 | 5500 |
I would like to show a Stacked bar Chart with the percentage of rows based on intervals. The output would be something like this:
The breakdown of the figures is:
| Sales Amount | % Total Sales |
| +1000 | 90% |
| +2000 | 50% |
| +3000 | 40% |
| +4000 | 30% |
| +5000 | 20% |
I have tried COUNTROWS or creating calculated tables and then unpivot the columns, but I don't make it. Could you please help me?
Thanks!
