Sorting

Hello, Hoping someone can please advise. Is there a way to deactivate or remove the sorting on a visual or matrix? My dataset is sorted the way I would like to see it, however, when I create a vis...

Need Help

edhans
6 years ago
You have to create a Sort By column. For example, if you have a file with Jan, Feb, Mar, Apr, it will not sort by month date, but alphabetically, so Apr, Feb, Jan, Mar. Useless. You want Jan to sort by 1, Feb by 2, Mar, by 3, etc.

So create a column in your data set that has the desired sort you want. You have to create the column. You cannot sort your data and expect that to work. It won't.

Then use the Sort By Columns functionality. See this article for details.
dax
6 years ago
Hi rrhascall ,

The viusal will sort by the columns in visual, so if you want to sort visual by specific in dataset, you need to set sort by in model like below

Then whe you use name column in visual, which will sort it by sort column.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.