cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
KKottha Frequent Visitor
Frequent Visitor

Line and stacked column chart

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

 

Customerstatus.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Line and stacked column chart

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

68.png

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.

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Line and stacked column chart

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

68.png

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.

 

KKottha Frequent Visitor
Frequent Visitor

Re: Line and stacked column chart

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

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 271 members 2,685 guests
Please welcome our newest community members: