Hi there, I'm trying to use a scatter chart with a categorical x-axis (i.e. it's more of a dot-plot than a scatter chart). I have sorted the values in my x-axis by an "order" column like below: ...
Thanks v-qiuyu-msft ,
Allowing blank values fixed the sorting issue for me. As Ed also commented would still be interesting to see how to resolve this without having to do this.
It seems like a very strange behaviour, and one that surely cannot be intentional in PowerBi's design.
Thanks,
A