How can I make the percentage of column total show up in a bar chart?

[Anonymous]

I'd like to show percentages instead of counts on the bar chart, like this. 

I tried this formula, but it's not calculating per quarter

% opp count per FQ =

DIVIDE(

COUNT(Sheet1[Opportunity Count]),

CALCULATE(COUNT(Sheet1[Opportunity Count]),ALLEXCEPT(Sheet1,Sheet1[Deal Size bucket]))

)

Also, I need this to work with filters. Is that possible? 

Here's a dummy .pbix 
https://drive.google.com/file/d/1jVgq4evyqQOz1xFo18kAwfWCnUn1-oxi/view?usp=sharing

[VasTg]

@Anonymous 

I moved the % mesuare to "Value" and the report shows % per quarter.

Do you want to keep the count as value but just display the % as labels? Your ask is not clear, please elaborate.

If it helps, mark it as a solution

Kudos are nice too.

[Anonymous]

@VasTg Sorry it was unclear. The column "% of opp count per FQ" is the formula I made and it's incorrect. The correct percentage for the first column should be 30%. There are four light blue columns, and a total of 10 units for Q1 FY20. The first coumn is 3, so it's 3/10, or 30% odf that quarter. Like this

[Anonymous · Accepted solution]

I got someone to help me. The answer was 

% opp count per FQ =
DIVIDE(
CALCULATE(SUM(Sheet1[Opportunity Count]),
     ALLEXCEPT(Sheet1,Sheet1[Deal Type],Sheet1[Quarter],Sheet1[Deal Size bucket]))
,
CALCULATE(sum(Sheet1[Opportunity Count]),
     ALLEXCEPT(Sheet1,Sheet1[Deal Type],Sheet1[Quarter]))
)