Forum Discussion
Sorting
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.
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 ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate the quick reply but as mentioned in my original post, i already have my dataset sorted via the method you outlined. The issue is my visual includes sorting by default based on the fields that I'm using and ignores my dataset sorting. I don't see away to remove the sorting from the visual itself.
I'm afraid you either have to use the sort by function, create a sort by column as edhans suggested, or simply resort to clicking the header of the column on the matrix to sort it. If you need it sorted an unorthodox way then creating a sort by column is your only method. You will need to create the sort by column for your "Rows" in the Matrix to get it to work properly.