This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
I have data in excel and I am easily able to crating 100% stached column chart in excel , but not able to make it in power BI , I want to create same as excel, please see the attached images. It is in Power BI
It is in Excel
Used Data
Solved! Go to Solution.
Hi @arifulice09
You should choose a 100% stacked column chart, see the picture below:
**Just a quick note
There is a logical problem in this graph because the amount you present is in percentages and it exceeds 100 percent in terms of correct data visualization.
Ideally, it would be best to separate the graph into two smaller ones and place them below the other.
It's up to you 🙂
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @arifulice09
You should choose a 100% stacked column chart, see the picture below:
**Just a quick note
There is a logical problem in this graph because the amount you present is in percentages and it exceeds 100 percent in terms of correct data visualization.
Ideally, it would be best to separate the graph into two smaller ones and place them below the other.
It's up to you 🙂
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thank you for your reply , but I want to see like as Excel chart ( i.e. the original value in chart ) for first column will be 52% instead of 100% and so on)
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 35 | |
| 32 | |
| 26 | |
| 21 | |
| 18 |
| User | Count |
|---|---|
| 68 | |
| 36 | |
| 32 | |
| 25 | |
| 23 |