need chart help

[Anonymous]

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.

region	required	received	percentage
A	12	12	100%
B	7	7	100%
C	14	12	86%

[Anonymous · Accepted solution]

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.

[selimovd]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

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

[medlalami]

Did you use the 100% Stacked column chart?