Line Chart Coloring based on slicer selection

[rishtinz]

I have this line chart with values for different weeks. In the legend I've a department classification. I want to have slicer with Department values and I'd like the user to select a department and the chart only colors that department. 

Line chart doesn't allow me to do conditional coloring. Does anyone have a work around? could we use Calculation Items in Tabular Editor? 

[PaulDBrown · Accepted solution]

Here is one way.

Create individual measures for each department. In my example they follow this pattern:

Classif A = 
CALCULATE(SUM(fTable[Classification]), 'Department Table'[Department] ="A")

Next create a new Field parameter with all the individual measures:

Next duplicate the individual measures you created. In my example following this pattern (same measure; different name):

Points A = CALCULATE(SUM(fTable[Classification]), 'Department Table'[Department] ="A")

Next set up the line visual including the duplicate measures and the measure created by the field parameter (the order is important; the field parameter measure must be at the bottom of the bucket):

Now format the line colour so that only those included in the field parameter measure have a colour (I've made the colours different but you can use the same colour for these if you wish).

 (I've also added selective labels for the FP parameter values)

And this is the result:

I've attached a sample PBIX file

[rishtinz]

This worked perfectly for me. I just have to tweek it to control my filters but everything else worked as I wanted it. Thanks so much Paul for taking the time to respond to my question. appreciate it.