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
The more I look at the picture you posted something is off...
You are sorting only 1 column - so it should sort at the County level
and if you have several cities in each County those should be sorted inside the county also
this is strange since you are only trying to sort 1 column
I tried to duplicate it but can't...
I have to say I've not had problems sorting only 1 Column
Good Luck! :smileyhappy:
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