I notice there's an issue when displaying by stacked chart.
the possible solution I thought is to filling the data in the fact table with 0 combine to all the possible dimension values combination.
but I think this would be digusting when the fact table is huge and when the etl loic is complicated in projects.
What I want to find if there's a way to sort the legend in front end or any other easier ways not to modify the fact table?
Thanks all in advance!