Forum Discussion
Color Change in Line Chart based on Slicer Value
Hi Team, Here, the requirement is to change the color of line or somehow we need to differentiate in color in line chart by using the numeric slicer value. Expecting an output like below. ...
Hi Peter_Jeyaraj_l
As I know, for line chart, you need to use static legend value to change the line color, so workaround are like below
You could create two meausres for line chart based on slicer value like below
more than max = var maxselcet=CALCULATE(MAX(slicer[Date]), ALLSELECTED(slicer[Date])) return if(MIN('table'[Date])>maxselcet, BLANK(),SUM('table'[Column 2]))
less than max = var maxselcet=CALCULATE(MAX(slicer[Date]), ALLSELECTED(slicer[Date])) return if(MIN('table'[Date])>maxselcet, SUM('table'[Column 2]), BLANK())
Or you could create a clustered column chart, then create a measure like below
Measure = var maxselcet=CALCULATE(MAX(slicer[Date]), ALLSELECTED(slicer[Date])) return if(MIN('table'[Date])>maxselcet, "#50C7C7","#CCA3E3")
use this in column chart's colditional format like below, then click line chart, it will change like below
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks for your response.
I tried and still see some challenges as i have all the info in same table. like below
Do i need to create any reference table to achieve the above
Deliver Quarter Operating Weeks Measure 2018-3 7 100 2018-4 8 120 Regards,
Peter I
