Once you have more than about 4-5 categories in your legend, the legend starts reusing colors. Is there some way to provide the legend with more colors than that so you don't sometimes have 2-3 categories with the same color.
Also, if you pass in data and use the FieldCategory, I take it does not group by the category value and creates duplicate keys with different colors, further complicating the first issue above.
Plus, making the 2 issues above even worse, even if the results in the chart do not have values (and are not visible) the legend still generates keys that are not present in the results?
See attachment shows all 3 things in action at once.
I think I could make this mostly (beside the reused colors) better by creating a helper to group/merge by category into a smaller dataset and then create subsets of that filtered where No>0.
Having to do that in a larger dashboard scenario adds a ton of plumbing for what I would assume should be groupable based on configuration settings with a shared data collection used by many charts on the same view.