Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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]))
)
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.
@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
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]))
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |