In a bar chart time series of year and month,highlight each bar every time when a new max is reached in the sales as below.
Solution:-
Step 1:-
Create Calculation that finds each new maximum starting from the first value. Then check to see if that value equals the current Sales value.
Step2:-
Drag the new calculation to the colors shelf. It Highlights record breaking months in orange and remaining in blue.
Thanks Guru's,
Prazval.ks