There seems to be a limit to the number of column series that can be shown in a stacked column chart. In the screenshot below, the black line is the total while the stacked bar shows the split of that total in different categories, they do not look like they are equal (and they should be).
If I limit the data to have less categories, then it is able to show the proper chart.
It would be great if :
- There were no limit, or at least a higher limit.
- Power BI does not complain about the fact there are too many categories. It should and make it very visible to the user that the data cannot be represented correctly. This is very problematic as it doesn't show the data properly (and so is a bug because of that).