Percentage Calculation on Stacked Bar Chart

[Roshan_Bhagi]

Hey,

I have the table below and I would like to calculate the aggregate percentage of A, B, C individually for FY23 and FY24. 

Type	Fiscal Year
A	FY23
A	FY23
A	FY23
B	FY24
C	FY24
B	FY24
A	FY24
B	FY23
C	FY23
B	FY24
C	FY23
C	FY24

I have populated the data in a stacked bar chart and the chart shows the aggregate percentages as follows: Please see chart below.

A: 25% for FY23 and 8% for FY24

B: 8% for FY23 and 25% for FY24

C: 17% for FY23 and 17% for FY24

Instead, I would like the chart to show the aggregate percentages of A, B, C by fiscal year as follows:

FY23            FY24

A: 50%         16%

B: 17%          50%

C: 33%          34%

I am a newbie to Power BI and any help from you guys is really appreciated. 

Thanks!

Roshan

[Anuja_Chaudhari · Accepted solution]

I have tried same and its working thanks for this something new to get learn .

[lbendlin]

[Roshan_Bhagi]

Hey,

Thank you for your quick response. 

I have applied the settings from the screenshot that you have shared; however, I don't see the desired percentages. 

Am I missing something?

Thanks!

Roshan

[v-yilong-msft]

Hi @Roshan_Bhagi ,

If you want to see percentages on your 100% Stacked Bar Chart view you can open Data labels under Visual.

If you need to remove the decimal point, you can do so, just set the Value decimal places under Detail to zero.

Then you will see what you want.

Best Regards

Yilong Zhou

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