Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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)
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 21 | |
| 21 | |
| 20 | |
| 20 | |
| 12 |
| User | Count |
|---|---|
| 58 | |
| 53 | |
| 39 | |
| 30 | |
| 26 |