Forum Discussion

New Member

2 years ago

Solved

Percentage Calculation on Stacked Bar Chart

Hey,

I have the table below and I would like to calculate the aggregate percentage of A, B, C individually for FY23 and 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
2 years ago

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

Anuja_Chaudhari
Helper I
2 years ago

I have tried same and its working thanks for this something new to get learn .
lbendlin
Super User
2 years ago
- Roshan_Bhagi
  New Member
  2 years ago
  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
  - Anonymous
    Not applicable
    2 years ago
    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.