Forum Discussion
Resolver ISorting a text column non-alphabetically without circular reference
hello markmsc
matrix visual has fewer sort option.
you can tweak this sort by various way.
1. define using number as prefix
2. if the prefix looks ugly, then you can create multiple measures. You can set placement by ordering those measures in value column matrix visual.
Hope this will help.
Thank you.
Resolver IOne other thing I tried, since I mentioned to Irwan that I am using a matrix viz...
I made the SizeSort column, and then added it as a column to the matrix, above Size. This sorts the columns by size correctly, because of course the first order sort is SizeSort 1-5. I then tried Show Next Level, thinking that perhaps even if SizeSort wasn't showing, the next level (Size) would still be sorted by it. Nope. It sorts alpahbetically when it is not visually enclosed within SizeSort in the matrix. For now I'm showing both SizeSort and Size in the viz, so that it sorts correctly, but I'd rather not do that.