Forum Discussion
Stacked Bar Graph - display Percentage
- Anonymous7 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.
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.
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-msft7 years agoMicrosoft Employee
Hi Anonymous,
Do you still need any other supports?
Best Regards,
Dale
- Anonymous7 years agoNot applicable
Hi Dale, Thank you for the followup.
Yes i need support on the below one if there is an possibility on the stacked bar chart.
4. The X-axis should display TOP on the stacked bar graph instead of in the BOTTOM.
Below is the expectation mockup:
- v-jiascu-msft7 years agoMicrosoft Employee