Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I'd like to create a line chart like the following one :
The part I'm struggling with is the split of the X axis by the Month_Status.
I tried the solution with the "concatenate labels" disabled option but as you can see in the image below, the values are linked between the two status and no separated.
Is there any way to workaround this ?
Thanks.
Solved! Go to Solution.
Hi @Anonymous,
Based on my test, you could refer to below steps:
Create four measures:
Measure = CALCULATE(SUM(Table1[NN_Conversion Rate]),FILTER('Table1','Table1'[NN_Cop]="Customer"&&'Table1'[Month_Status]<>"Temporary"))
Measure2 = CALCULATE(SUM(Table1[NN_Conversion Rate]),FILTER('Table1','Table1'[NN_Cop]="Prospect"&&'Table1'[Month_Status]<>"Temporary"))
Measure3 = CALCULATE(SUM(Table1[NN_Conversion Rate]),FILTER('Table1','Table1'[Month_Status]="Temporary"&&'Table1'[NN_Cop]="Customer"))
Measure 4 = CALCULATE(SUM(Table1[NN_Conversion Rate]),FILTER('Table1','Table1'[Month_Status]="Temporary"&&'Table1'[NN_Cop]="Prospect"))
Result(create a Line and clustered column chart):
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi @Anonymous,
Could you please share me some sample data to have a test?
Regards,
Daniel He
Hello @v-danhe-msft,
Here's the data I'm testing on :
NN_Cop;Month_Status;NN_Month;NN_Conversion Rate Customer;Final;1/01/2017;0,3151 Customer;Final;1/02/2017;0,3544 Customer;Final;1/03/2017;0,311 Customer;Final;1/04/2017;0,3284 Customer;Final;1/05/2017;0,374 Customer;Final;1/06/2017;0,3088 Customer;Final;1/07/2017;0,3602 Customer;Final;1/08/2017;0,3796 Customer;Final;1/09/2017;0,3434 Customer;Final;1/10/2017;0,3426 Customer;Final;1/11/2017;0,3508 Customer;Final;1/12/2017;0,3422 Customer;Temporary;1/12/2017;0,2857 Prospect;Final;1/01/2017;0,063 Prospect;Final;1/02/2017;0,0769 Prospect;Final;1/03/2017;0,0717 Prospect;Final;1/04/2017;0,061 Prospect;Final;1/05/2017;0,0826 Prospect;Final;1/06/2017;0,1076 Prospect;Final;1/07/2017;0,064 Prospect;Final;1/08/2017;0,0824 Prospect;Final;1/09/2017;0,0581 Prospect;Final;1/10/2017;0,112 Prospect;Final;1/11/2017;0,0638 Prospect;Final;1/12/2017;0,0414 Prospect;Temporary;1/12/2017;0,1538
Thank you very much.
Tus
Hi @Anonymous,
Based on my test, you could refer to below steps:
Create four measures:
Measure = CALCULATE(SUM(Table1[NN_Conversion Rate]),FILTER('Table1','Table1'[NN_Cop]="Customer"&&'Table1'[Month_Status]<>"Temporary"))
Measure2 = CALCULATE(SUM(Table1[NN_Conversion Rate]),FILTER('Table1','Table1'[NN_Cop]="Prospect"&&'Table1'[Month_Status]<>"Temporary"))
Measure3 = CALCULATE(SUM(Table1[NN_Conversion Rate]),FILTER('Table1','Table1'[Month_Status]="Temporary"&&'Table1'[NN_Cop]="Customer"))
Measure 4 = CALCULATE(SUM(Table1[NN_Conversion Rate]),FILTER('Table1','Table1'[Month_Status]="Temporary"&&'Table1'[NN_Cop]="Prospect"))
Result(create a Line and clustered column chart):
You could also download the pbix file to have a view.
Regards,
Daniel He
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |