Line and stacked column chart

[Anonymous]

Hi,

I have below visual  Line and stacked chart

But I need new customers in the line and existing in the bar. Is that possible?

I have attached sample data also to make it clear

I want to see the "newcustomer" status as a line..it is coming as Count now. Thanks in advance

[dax · Accepted solution]

Hi KKottha,

I am not very clear about your requirement, did you want to add a line in chart? If so, you could try to count newcustomer, then add this in Line values. Like below

count new user = CALCULATE(COUNT(chart[name]), FILTER(chart, chart[status]="new"))

If possible, could you please inform me more detailed information, such  as your sample data and your expecting output? Then I will help you more correctly.

Best Regards,

Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Almost I did like same. 

#ExistingCustomersRevenue = CALCULATE([Revenue],'New Accounts'[CUSTOMERSTATUS] = "ExistingCustomer") and for the New also I did same and In column values I used ExistingCustomerRevenue and in Line Values I used newCustomerRevenue

Thank you