As usual, a workaround presents itself right after posting the question. If anyone in the future have the same issue I managed to solve it by:
-
Add an enum in the data model and assign a lot of colors to it
-
Add a run time property to the dataset object, and set type to this enum:
-
Set this as the color value in the chart. The chart will then pick each color in the order defined by the enum, even if none of the records have been assigned a value.
Would love to know if anyone have found a better solution? 