I have a requirement where user can select any 3 products from the slicer, and the bar/line combo chart should show the bar for each products in different color.
Is there any way to do it ? If I had code the color to a particular product, it may not work when user selects some other product.
Basically I am looking for Position based color coding of the bar. 1st position red, 2nd position black, 3rd position blue, something like this.
There are two workarounds you can try.
1. Assign a color for each product.
2. Add the same column of Axis to the legend.
Problem with this approach is if we have thousands of Product, we cannot set colors for all.
And also line and Clustered Column chart does not have legend featue. Is there any other alternative ?