Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 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%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.

 

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

7 Replies

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

     

    • Anonymous's avatar
      Anonymous
      Not 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's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee

        Hi Anonymous,

         

        Do you still need any other supports? 

         

        Best Regards,

        Dale