Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
One query on Line & Stacked column chart implementation.
I need to show Percentages instead of Numbers in Power BI- Stacked column chart
The data set example is provided below.
Country | Sales | Business/Customer |
France | 2000 | B |
France | 1000 | C |
UK | 3000 | B |
UK | 2000 | C |
Germany | 4000 | B |
Germany | 1000 | C |
Spain | 2000 | B |
Netherlands | 2000 | B |
Netherlands | 500 | C |
Italy | 1000 | B |
Italy | 200 | C |
Portugal | 1200 | B |
Portugal | 300 | C |
The visual I'm trying to generate is provided below.
The only change required is instead of numbers it should show percentages.
Ex. For Germany, in Business it should be 4000/5000 = 80%, whereas for Customer it should be 1000/5000 = 20%
Also the column length is based on the total sales for each country.
Can you please help with what can be the possible tweak in Power BI which would help me get to this final state.
Thanks 🙂
Regards,
Varun
Hi @Anonymous
Use 100% stacked column chart.
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar
If I resolve your problem Mark it as a solution and give kudos.
@Anonymous
The idea is not to use 100% stacked column chart. As I want the 'Sales' for each country to determine the size of the columns (and not by 100% value).
Hi, I have not implemented this yet myself, but I came across this article a few weeks ago - I believe it's what you're looking to accomplish and seems fairly simple: https://bielite.com/blog/percent-data-labels/. Good luck!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |