I have a very specific requirement to highlight certain bars in a Bar Chart without changing original colors of the bars.
Current scenario: Data infotable is bound to Chart and chart adjusts and displays bars according to the data value with different color for all bars.
Expected: Data infotable has 2 values beyond threshold and chart should highlight those 2 bars in red color and rest of the bars should remain in original(different) colors.
Tried and didn't work: Applied state formatting with a threshold value which turns all the bars meeting condition in red color and rest of them in another single color. Attached is the screenshot of the same.
Example: Display top 2 fruits bars in red which has highest sales i.e. Banana and Pear.