Conditional Formatting on Line and stacked column chat

Hi PPStar ,

I created a sample pbix file(see attachment) for you base on your provided info.

1. Create a measure [color].

Color = 
var t1 =MAX('Table'[Value])
RETURN
SWITCH(
    TRUE(),
    t1 >=50, 1,
    t1 <=30, 2, 3
    )

2. Make conditional formatting on Columns field(not Lines field) .

3.Conditional formatting cannot filter rows based on thresholds, and we can create a measure that shows the "year & month" that reached the threshold.

Measure = 
var _threshold=20
var _b=CALCULATE(MAX('Table'[Value]),FILTER('Table',MAX('Table'[Value])=_threshold))
return _b

You may find the solutions in similar posts below to find it helpful.

Solved: Increasing and Decreasing trend color in line char... - Microsoft Power BI Community

Solved: Customize Column Colors in Stacked Column based on... - Microsoft Power BI Community

Line stacked column chat not updating field format... - Microsoft Power BI Community

Best Regards,

Neeko Tang

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