Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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%2...
  • Anonymous's avatar
    Anonymous
    7 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. 

     

  • Anonymous's avatar
    Anonymous
    7 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.

     

     

  • Anonymous's avatar
    Anonymous
    7 years ago

    Morning Dale,

     

    Yesterday seems there was an Issue.  But today i was able to post the idea on the page.

     

    Thanks.