Forum Discussion
Box Plot color consistency
Hi MartynRamsden I appreciate the suggestion, but the problem I am having is that when I filter down the data based on several different criteria, the population size decreases. This means that sometimes "W" has no records to build a boxplot and then my colors shift or don't stay the same. Here is a screenshot of the "Data Colors" area and as you can see "W" can not be found:
I've done some testing and now fully understand your issue. Unfortunately, I don't think there's a solution.
I was under the impression that when using the 'Data colours' formatting option, you were assigning colours directly to categories - it appears this isn't the case in this visual!
It looks like the colours are actually being assigned to the order the categories appear in. Hence, if a category is filtered out, the remaining visible categories will change colour, as you're seeing.
Most of the built in Power BI visuals now support Conditional Formatting but this isn't an option in the Box Plot visual you're using.
Sorry I can't be of any more help!
Best regards,
Martyn
Thanks MartynRamsden - you are spot on. The colors are based upon sorting, unfortunately. At this moment I do not know a better way to color the boxplots. Oh well! I'll keep trying.