Forum Discussion
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
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.
2 Replies
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.