cancel
Showing results for
Did you mean:
Highlighted

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

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
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

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]))
)

3 REPLIES 3
Highlighted
Super User II

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

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.

Highlighted

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

@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

Highlighted

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

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]))
)

Announcements

#### August Community Highlights

Check out a full recap of the month!

#### August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

#### Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors