Forum Discussion

Iaguas's avatar
Iaguas
Frequent Visitor
1 year ago
Solved

Multiple lines in line graph based on two multiselect slicers

Hello everyone, I need to make a dynamic line chart with multiple lines based on two or more multi-select slicers. I know I can do it with one multi-select slicer by adding my data in the legend and...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the reply from lbendlin.

     

    Hi Iaguas ,

     

    Please try the following steps:

     

    1.Create a new column.

     

     

    Segment&State = 'Table'[Segment]&"&"&'Table'[State]

     

     

     

    2.Create a line chart and use the column created as legend.

     

    3.Result:

     

     

    Best Regards,
    Zhu

     

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

     

Iaguas's avatar
Iaguas
Frequent Visitor
1 year ago

This is fictitious data, not real and not confidential.

Order DateSegmentStateSales
09/11/2013ConsumerKentucky261,96
09/11/2013ConsumerKentucky731,94
13/06/2013CorporateCalifornia14,62
11/10/2012ConsumerFlorida957,5775
11/10/2012ConsumerFlorida22,368
09/06/2011ConsumerCalifornia48,86
09/06/2011ConsumerCalifornia7,28
09/06/2011ConsumerCalifornia907,152
09/06/2011ConsumerCalifornia18,504
09/06/2011ConsumerCalifornia114,9
09/06/2011ConsumerCalifornia1706,184
09/06/2011ConsumerCalifornia911,424
16/04/2014ConsumerNorth Carolina15,552
06/12/2013ConsumerWashington407,976
22/11/2012Home OfficeTexas68,81
22/11/2012Home OfficeTexas2,544
11/11/2011ConsumerWisconsin665,88
13/05/2011ConsumerUtah55,5
27/08/2011ConsumerCalifornia8,56
27/08/2011ConsumerCalifornia213,48
27/08/2011ConsumerCalifornia22,72
10/12/2013CorporateNebraska19,46
10/12/2013CorporateNebraska60,34
17/07/2014ConsumerPennsylvania71,372
25/09/2012ConsumerUtah1044,63
16/01/2013ConsumerCalifornia11,648
16/01/2013ConsumerCalifornia90,57
17/09/2012ConsumerPennsylvania3083,43
17/09/2012ConsumerPennsylvania9,618
17/09/2012ConsumerPennsylvania124,2
17/09/2012ConsumerPennsylvania3,264
17/09/2012ConsumerPennsylvania86,304
17/09/2012ConsumerPennsylvania6,858
17/09/2012ConsumerPennsylvania15,76
20/10/2014Home OfficeTexas29,472
09/12/2013CorporateTexas1097,544
09/12/2013CorporateTexas190,92
27/12/2012Home OfficeTexas113,328
27/12/2012Home OfficeTexas532,3992
27/12/2012Home OfficeTexas212,058
27/12/2012Home OfficeTexas371,168
11/09/2014CorporateIllinois147,168
18/07/2013CorporateCalifornia77,88
20/09/2014CorporateFlorida95,616
12/03/2013CorporateMinnesota45,98
12/03/2013CorporateMinnesota17,46
20/10/2011ConsumerMichigan211,96
21/06/2013ConsumerDelaware45
21/06/2013ConsumerDelaware21,8
18/04/2012ConsumerIndiana38,22
18/04/2012ConsumerIndiana75,18
18/04/2012ConsumerIndiana6,16
18/04/2012ConsumerIndiana89,99
12/12/2013CorporateNew York15,26
12/12/2013CorporateNew York1029,95
18/06/2013ConsumerNew York208,56
18/06/2013ConsumerNew York32,4
18/06/2013ConsumerNew York319,41
18/06/2013ConsumerNew York14,56
18/06/2013ConsumerNew York30
18/06/2013ConsumerNew York48,48
18/06/2013ConsumerNew York1,68
24/11/2012ConsumerCalifornia13,98
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks for the reply from lbendlin.

 

Hi Iaguas ,

 

Please try the following steps:

 

1.Create a new column.

 

 

Segment&State = 'Table'[Segment]&"&"&'Table'[State]

 

 

 

2.Create a line chart and use the column created as legend.

 

3.Result:

 

 

Best Regards,
Zhu

 

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

 

  • Iaguas's avatar
    Iaguas
    Frequent Visitor
    1 year ago

    Thank you very much for your help!