cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tusozor Regular Visitor
Regular Visitor

Split line chart axis by categories

Hello,

 

I'd like to create a line chart like the following one :

 

SASVA_Split_LINECHART.png

 

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.

 

POWERBI_Split_LINECHART.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
v-danhe-msft Super Contributor
Super Contributor

Re: Split line chart axis by categories

Hi @Tusozor,

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

1.PNG

You could also download the pbix file to have a view.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
v-danhe-msft Super Contributor
Super Contributor

Re: Split line chart axis by categories

Hi @Tusozor,

Could you please share me some sample data to have a test?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Tusozor Regular Visitor
Regular Visitor

Re: Split line chart axis by categories

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

v-danhe-msft Super Contributor
Super Contributor

Re: Split line chart axis by categories

Hi @Tusozor,

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

1.PNG

You could also download the pbix file to have a view.

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 1,039 guests
Please welcome our newest community members: