Forum Discussion
Matrix Total Column sort
Sean Thanks for the heads up--I just figured matrix sorting was funky. Since the data is in a measure and a slicer determines what's shown on the table...sometimes the data is $ other times it's a count...I format it when building the measure. And that makes it sort as text. I could not for the life of me figure out what was happening, but it's sorting left to right, one place at a time. And, even if the data being chosen has a format, that can't be passed along to the measure. Grrrr.
Anyway, thanks for the heads up. Tom
Yes ThomasDay I am amazed when I see some people claim you can sort in the Matrix!
If you have indeed seen the Ideas you surely have seen my post(s) specifically on Sorting!
A quick fix for you (although I know this will not be what you want exactly)
Reverse the order of county and primary city - then they'll sort correctly but not like you want the results to look!
We need to be able to sort at each level as I explained here
You can see my comment 5th form top
Plus I've been asking for the Collapse/Expand Buttons since Aug 2015