Producing Pie Charts and Bar charts via percentages for groups

[lennox25]

Hi, 

I wonder if someone can help?

I have 3 stores, Red, Pink.  For Red and Pink, I have cards detailing units sold between: (Small)0-100, (medium)101-500 (large) 501+. Which is great. On PBI I need to create a a bar chart showing both stores and the % of small, medium and large units sold. I also need to create a pie chart again in % showing % of small stores units sold v % of total units sold.

I attach PBI Sample report if anyone would like to take a look. Thank you.

https://drive.google.com/file/d/1GYAYxZaBMaxY5beGC-NRbI87lBxfNPte/view?usp=sharing 

[Jayee]

Hi @lennox25 ,

Use below measure for bar chart it will work same as Pie chart shows and make sure format measure as Percentage

% Rage Measure =
DIVIDE (
[Range Measure],
CALCULATE (
SUMX (
SUMMARIZE (
'Units Sold Range',
'Units Sold Range'[Range],
"X", [Range Measure]
),
[X]
),
ALL ( 'Units Sold Range' )
),
0
)

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

[lennox25]

Hi @Jayee  -  What Im after is a pie chart (which Ive done in Excel) that looks like this. Is this possible?

[v-xiaotang · Accepted solution]

Hi @lennox25 

please refer to my solution in this post with the similar question, Solved: Make pie chart show % of total population when fil... - Microsoft Power BI Community

Here are 2 solutions in that post for your reference,

For example, you can create a table containing ‘All Stores' and 'Small Stores'.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

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

[Jayee]

Hi @lennox25 

If you have data structure in power bi same as excel you have while creating this Yes it is possible.

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

[Jayee]

Hi @lennox25 ,

For Pie Chart select Range Measure and Range fields in pie chart and in format options select "Percent of total"

Thanks,
Jay

[lennox25]

Hi @Jayee  - Thank you for this. But what I need is to show the % of Small along with % of Total so it would look like 52% Small and 48% Total.