Forum Discussion
Line Chart Coloring based on slicer selection
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
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
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.
