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.
Hi,
I'm new with PowerPivot (Power BI), I'm tryingo to build a very simple combo chart as "A" but having the clustered columns broken down as "B" (by Status), the issue I'm having is that the orange line "AdoptionPct" in chart "B" once I add the Status series goes to 100% in all clustered columns and I'd like to keep it as in chart "A".
My dataset and measures
Status Company Total
Adopted | AVE | 521 |
Adopted | CORE | 280 |
Adopted | FV | 2253 |
Adopted | PTP | 161 |
Not Adopted | AVE | |
Not Adopted | CORE | |
Not Adopted | FV | 1 |
Not Adopted | PTP | |
To be Adopted | AVE | 77 |
To be Adopted | CORE | 9 |
To be Adopted | FV | 93 |
To be Adopted | PTP | 10 |
GrandTotal:=CALCULATE(SUM(Table1[Total]))
Total_Adopted:=CALCULATE(SUM(Table1[Total]),FILTER(Table1,Table1[Status]="Adopted"))
Total_Not_Adopted:=CALCULATE(SUM(Table1[Total]),FILTER(Table1,Table1[Status]="Not Adopted"))
Total_ToBeAdopted:=CALCULATE(SUM(Table1[Total]),FILTER(Table1,Table1[Status]="To be Adopted"))
AdoptionPct:=DIVIDE([Total_Adopted],[GrandTotal],0)
Hopefully I was clear enough explaining the issue.
Thanks in advance.
Solved! Go to Solution.
Hi @Anonymous ,
In order to achieve the effect you want, you need to change the measure AdoptionPct to the following formula:
AdoptionPct :=
DIVIDE (
[Total_Adopted],
CALCULATE ( SUM ( Table1[Total] ), ALLSELECTED ( Table1[Status] ) ),
0
)
The following are the results before and after the change:
Before change:
After change:
Here is a demo, please try it:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
In order to achieve the effect you want, you need to change the measure AdoptionPct to the following formula:
AdoptionPct :=
DIVIDE (
[Total_Adopted],
CALCULATE ( SUM ( Table1[Total] ), ALLSELECTED ( Table1[Status] ) ),
0
)
The following are the results before and after the change:
Before change:
After change:
Here is a demo, please try it:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks a lot @Anonymous-msf,
It worked as a charm, I appreciate your help!
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |