Forum Discussion
How to sort measure by another column
Hi Ritaf1983,
It did work for me.
Correct me one thing, is the dynamic measure formatting is not suported in direct query mode?
In import mode it worked.
Hi Ritaf1983 ,
Thanks for answers. It seems dynamic formatting wont work with direct query mode.
Super UserHi Anonymous
So unfortunately, I doubt there’s an elegant way to handle this 😞 It’s possible to add a ranking column to the table, but it’s still an additional column... And every time a user tries to sort by the actual amounts, the sorting will break.
i attached a pbix with this option just to be on the safe side 🙂
And it’s really, really problematic in that same visualization to mix formats. I did an experiment like this in one of the meetups I led on data visualization, and people either got confused or took time to understand who’s bigger than whom in such cases. So maybe in this specific case, it’s more of a feature than a bug 🙂
P.s you marked your reaction to me as a solution is this what you meant or it is a mistake?
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Ritaf1983 ,
Thanks a lot for your effort.
yes creating a rank column will not work since the users always want to sort the sales measure column only.
Seems like no way we can do it.