Combo chart, how keep single line series unaffected by Legend(Series)

[Anonymous]

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.

[v-joesh-msft · Accepted 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：

https://qiuyunus-my.sharepoint.com/:x:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EUgT6XRhQZRIn5qI1Px2E4EBXKi4Nwwm-oF4Jgcso3J3rA?e=PRodwX

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.

[Anonymous]

Thanks a lot @Anonymous-msf,

It worked as a charm,  I appreciate your help!