Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

need chart help

Hi,

 

Need a chart help with below data. Client wat to see with 100% stacked bar,but could not get proper chart in power bi. tried to use "line and stacked column chart", "line and clustered column chart", but does not make client happy.

any more chart suggesitions are highly appreciated.

 

regionrequiredreceivedpercentage
A1212100%
B77100%
C141286%
    
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    I'm not sure I've understood you accurately, so please check the following chart to see if it's the result you're expecting.

     

    You can drag the columns into the X-axis and Y-axis respectively as shown above.

    Then click the formatting of this Chart, turn on display data label options.

     

    If the Percentage display is incorrect, you can change the format of the Percentage column in the table view.

     

     

    A demo for your reference is attached.

     

    Hope it helps,


    Community Support Team _ Caitlyn Yan

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

4 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey Anonymous ,

     

    as medlalami  mentioned try one of the two following charts:

     

    They will automatically scale to 100% bars.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks for quick reply. I tried above two charts, but no luck.

      The percentage bar is showing 100% bar when added one field. But after adding other fields it is divididng into percentages.

       

      But I want to show 100% bar along with other fields (required and received). Data labels are dividing into 48.57, 48.57 and 2.86. But it should not be. The 100% percentage data label has to show 100% and required has to show label number 7 and received has to show label number 7.

       

      PLease help.

       

      Attached sample pbix file

       

      https://drive.google.com/drive/folders/1HGiE1ND5XhzdW5xj2xWChhXI0W8mtmSe?usp=sharing

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    I'm not sure I've understood you accurately, so please check the following chart to see if it's the result you're expecting.

     

    You can drag the columns into the X-axis and Y-axis respectively as shown above.

    Then click the formatting of this Chart, turn on display data label options.

     

    If the Percentage display is incorrect, you can change the format of the Percentage column in the table view.

     

     

    A demo for your reference is attached.

     

    Hope it helps,


    Community Support Team _ Caitlyn Yan

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.