Forum Discussion
Stacked Bar Graph - display Percentage
Hi,
New to powerbi and working on Category Bar Graph.
please refer to the below link to download the attached category bar graph pbix.
https://www.dropbox.com/s/e9aiqq0fv9ocxm8/category%20bar%20graph.pbix?dl=0
Attached the CategoryTable Data screenshot for reference in case if pbix file is not downloaded.
Need help on the below ones,
1. The Y- axis should include percentage symbol.
I have tried to select Percentage column --> click Modeling tab --> select Format as Percentage
But I see the based on the Vehicle1 data, values on the Y-axis are displayed as 0% 500% 1000% 1500% 2000% ... instead of 0% 5% 10% 15% 20% .... Attached the screenshot for reference.
2. On Hoover on the individual category bar display the percentage value (ex: for Category "Wheel" on hoover display 87.50% as per the provided Category Bar graph pbix file)
3. Display the category highest percentage value on the bar i.e. 87.50% (say in a Card Visualization).
4. The Y-axis should display TOP on the bar graph instead of in the BOTTOM.
Attached the sample expected behaviour mockup for the above 4 points.
- Anonymous8 years ago
Hi, Thought to share my findings:
I am not sure if i followed the right procedure but I was able to fix below 1 and 2 items. Please advise if i am right?
Need help to fix other two i.e. 3 and 4 items requested in the intial post.
1. The Y- axis should include percentage symbol.
2. On Hoover on the individual category bar display the percentage value (ex: for Category "Wheel" on hoover display 87.50% as per the provided Category Bar graph pbix file).
Attached the mockup for reference.
Followed below steps to fix the above 2 points:
1. Created a column newpercent. Attached mockup for reference.
2. then dragged the newpercent column to the stacked bar chart Value field and then selected show value as --> Percent of grand total. Attached mockup for reference.
3. In visual level filter --> with in Category used the newpercent value and set it as Standard deviation and filtered for Top 5 --> click on Apply filter. Attached mockup for reference.
- Anonymous7 years ago
Hi,
Thought to share the below information if some one is looking for similar functionality.
I was able to fix the 3rd requirement which i have requested in my intital post. refer the link below
3. Display the category highest percentage value on the bar i.e. 87.50%
https://community.powerbi.com/t5/Desktop/Stacked-Bar-Graph-display-Percentage/m-p/514004
Used Data Labels Format to fix it.
Select stacked bar chart --> click on Formats icon --> expand Data Labels and apply the value decimals places, display units, position etc properties based on the usecase. refer the attached mockup below.
- Anonymous7 years ago
Morning Dale,
Yesterday seems there was an Issue. But today i was able to post the idea on the page.
Thanks.
7 Replies
- AnonymousNot applicable
Hi, Thought to share my findings:
I am not sure if i followed the right procedure but I was able to fix below 1 and 2 items. Please advise if i am right?
Need help to fix other two i.e. 3 and 4 items requested in the intial post.
1. The Y- axis should include percentage symbol.
2. On Hoover on the individual category bar display the percentage value (ex: for Category "Wheel" on hoover display 87.50% as per the provided Category Bar graph pbix file).
Attached the mockup for reference.
Followed below steps to fix the above 2 points:
1. Created a column newpercent. Attached mockup for reference.
2. then dragged the newpercent column to the stacked bar chart Value field and then selected show value as --> Percent of grand total. Attached mockup for reference.
3. In visual level filter --> with in Category used the newpercent value and set it as Standard deviation and filtered for Top 5 --> click on Apply filter. Attached mockup for reference.
- AnonymousNot applicable
Hi,
Thought to share the below information if some one is looking for similar functionality.
I was able to fix the 3rd requirement which i have requested in my intital post. refer the link below
3. Display the category highest percentage value on the bar i.e. 87.50%
https://community.powerbi.com/t5/Desktop/Stacked-Bar-Graph-display-Percentage/m-p/514004
Used Data Labels Format to fix it.
Select stacked bar chart --> click on Formats icon --> expand Data Labels and apply the value decimals places, display units, position etc properties based on the usecase. refer the attached mockup below.
- v-jiascu-msft
Microsoft Employee
Hi Anonymous,
Do you still need any other supports?
Best Regards,
Dale